December 12, 2002 at 5:30 am
Hi,
We are currently having a few problems with Lock and Deadlocks on our SQL Server (Previous post)
One question, our current Sql server Spec is as follow:
SQL server 7
Window NT 4
Total Hard Disk Space 12 G (Free = 4 G)
386 MB RAM
500 Mhz Intel PII processor
Hard Disk Drive is IDE NOT SCSI
We have in total about 30 Databases, which have all web applications accessing them.
Mostly low traffic but our main database is getting accessed and updated constantly, hense the locking problems!!!
Do we need to upgrade this Spec; if we did upgrade would this improve our lock problem, as we seem to using the TempDB a lot??
Thanks,
Sean Martin
December 12, 2002 at 7:27 am
Its not really solving the problem, an upgrade might make things run faster and thus locks are not held for as long but if your website gets mroe usage you will be back in the same situation.
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
http://www.amazon.co.uk/exec/obidos/ASIN/1904347088
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
December 12, 2002 at 9:29 am
I think Simon is correct.
I would turn on the Performance Monitor in NT and look at Processor Utilization, Average Disk Queue length and sec/Transfer. In SQL I would look at the following counters for memory:
Buffer Cache Hit ratio
Page life expectancy and
Target Server Memory
If those values indicate some system level bottleneck then I would upgrade hardware...
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply