The largest performance problem when this occurs is in attempting to view anything via Enterprise Manager. I can't get any response when the locks...
I received this error yesterday when I had a large number of locks and high lock/latch waits.
I am experiencing a very high number of locks by a Cognos tool. The locks are exclusive extent locks on the temp database. As an example, I have a...
Another interesting note. There are processes that show to be blocking process 1 (lazy writer), however when you look at the lazy writer process it...
Thank you for the advice, althought I could have sworn I read somewhere that DSS should be fixed, but I cannot find that supporting information now....
I have tried sql profiler several times and cannot find the right event to track to display this. I have tried stored procedure - statement...
We have a third party tool (ie Cognos) that connects to the database and executes queries. Through the management console, I can only see that it is...
The current memory setting is fixed at 1725MB. The box has 2GB memory and is dedicated to SQL Server.
OK - I understand what it is doing, but why would my insert process block the lazy writer? I can see why the lazy writer might block or slow down my...
This problem resolved itself, but can someone help me understand why it existed and what I can do to avoid it?
I've got a process doing an "insert into.. select from.." and it is blocking the LAZY WRITER process. Doing a dirty read, I can see that the process...
Crispin - one other question. How many DBA's do you have in addition to yourself managing these databases? Thanks!
Crispin - is your environment DSS or OLTP? Thank you! Peggy
Crispin - when you say DB's? Do you have several DB's totaling over 4TB? Or several databases, each over 4TB?
Thank you for the link. Is your friend's DB a clustered instance or single?
We are looking for information on the largest SQL Server configuration you have seen (working) either clustered or non-clustered. How many servers?...
We have solved our problem regarding this issue. After analyzing the right pieces of data, this came down to a specific query. It did not affect...
Completely agree that the concept of SQLServer "sleeping" doesn't make much sense. Technically, it is actually processing rows. You can see inserts...
We have seen a similar problem with a store procedure that is pulling from one table, performing some transformation and inserting into another....
Separate names with a comma.
