Windows Thread, Policy Central verrrrry slow database access since server move in Technical; This may be something I need to contact Forensic software about, but I know there are a few here that ...
26th April 2010, 02:17 PM #1
Policy Central verrrrry slow database access since server move
This may be something I need to contact Forensic software about, but I know there are a few here that use PCE and even more than might be able to diagnose a SQL problem.
Over easter we moved our database over to a new server. Its a virtual one, 2003 R2 running on Hyper-V with 2Gb RAM dedicated to it and a well specced CPU (with little else running on Hyper-V so far)
Followed instructions, everything went fine, all works perfectly, but when you try and display a page of captures it takes 20-30 seconds to load - on the old server it took about 3 or 4 seconds. Everything else on the web interface is speedy as it should be, its just when listing a large amount of captures.
If I go on the server, CPU usuage is on 100% for the whole time the page is loading, then drops back to nothing. Was just wondering, is there any tool I can use to see what the database is doing when the request is made?
When we transferred the database, we had to leave all the old captures behind, because there was 150GB+ of them, we no longer needed them and with 500,000 odd files it would have taken all day to copy them. So the database contains references to all these captures, but unsurprisingly they display a message that the images couldnt be found. Is there a possibility this could have something to do with it?
IDG Tech News
26th April 2010, 03:56 PM #2
I would say this is probably more than likely the case as it's searching for this information, but by all means check with Forensic.
By techie08 in forum Windows
Last Post: 26th March 2010, 02:06 PM
By Little-Miss in forum General Chat
Last Post: 2nd October 2009, 06:03 PM
By Little-Miss in forum Educational Software
Last Post: 29th September 2009, 08:08 PM
By button_ripple in forum MIS Systems
Last Post: 1st May 2009, 09:17 AM
By ind13 in forum Windows
Last Post: 20th July 2006, 11:48 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)