+ Post New Thread
Results 1 to 2 of 2
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 ...
  1. #1

    Join Date
    Jul 2006
    Location
    London
    Posts
    2,962
    Thank Post
    160
    Thanked 152 Times in 116 Posts
    Rep Power
    49

    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?

  2. #2

    Michael's Avatar
    Join Date
    Dec 2005
    Location
    Birmingham
    Posts
    9,266
    Thank Post
    242
    Thanked 1,575 Times in 1,254 Posts
    Rep Power
    341
    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.

SHARE:
+ Post New Thread

Similar Threads

  1. Policy Central and Sophos
    By techie08 in forum Windows
    Replies: 6
    Last Post: 26th March 2010, 01:06 PM
  2. Policy Central
    By Little-Miss in forum General Chat
    Replies: 3
    Last Post: 2nd October 2009, 05:03 PM
  3. Policy Central
    By Little-Miss in forum Educational Software
    Replies: 13
    Last Post: 29th September 2009, 07:08 PM
  4. No access to any database on SQL server
    By button_ripple in forum MIS Systems
    Replies: 2
    Last Post: 1st May 2009, 08:17 AM
  5. Policy Central
    By ind13 in forum Windows
    Replies: 1
    Last Post: 20th July 2006, 10:48 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •