When monitoring our production database server during peak times, I notice that the Key lock requests per second average about 600,000. Does this seem high to anyone but me? Any thoughts would be appreciated.
Thanks,
John
At my company we recently needed to reload SQL 7 on one of our production servers. We then loaded SQL SP2 on it. Later we realized that none of the perfmon counters are showing up for SQL. I tried the whole unlodctr and lodctr routine but it didn't help. Anyone have any suggestions on how to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.