August 18, 2005 at 4:00 am
Hi
I'm new to SQL Server, so can someone please please help.
Problem : using SQL Server 2000, on Windows 2003 Std Edition. We have 4CPU's and 1G Ram.We made a copy of our Live DB & restored it to DEV DB on Friday and ever since, performance on DEV has been impossible ! You can only run one query at a time, if you attempt another you get the error 1222: lock timeout occurred. Any query u run uses almost all memory for sql server, and anything you do, the memory climbs and climbs, and does not get released (I understand that memory increasing is normal in sql server, but it does not release unless you stop and start the service.)
lock timeout is set to -1
Applied SP4 for sql server
Its only happening on the 16 GB database - the smaller databases are fine. Do we need to increase the amount of memory? Any other suggestions?
Thank You
Huda
August 19, 2005 at 2:22 am
AFter restoring the database to a new database did you change the logical filenames for the database and log files?
August 19, 2005 at 5:44 am
I would recommend an extra 1 GB as it is quite cheap these days.
Are the two queries related to each other?
Is the first a long running one?
August 19, 2005 at 8:40 am
I agree with Jo, upgrade memory. But you also want to research the offending query.
Questions
What is the level of the locks?
What kind of locks are you experiencing?
August 19, 2005 at 9:42 am
I have seen many posts regarding SP4 negatively inpacting queries/stored procedures speed. If you can try on a dev server with SP3a not SP4.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply