Archive for January 4th, 2008

SQL Counter: Part 2 (Processor Queue Length) January 4th, 2008

Vinod Kumar

System Object -> Processor Queue Length
Watch the value over a sustained period of time to see if the CPU is a bottleneck. The counter measures how many threads are waiting for processor time. The count includes all threads that are “ready” and not waiting on some other thing such as I/O to complete. The general rule of thumb is that this value should be less than two times the number of processors in the system. If it is growing over time and the CPU % is greater than 80%, more or faster processors are probably needed.

Continue reading...


 

Sync Services for ADO.NET 2.0 January 4th, 2008

Vinod Kumar

Check the post on whatz new on Sync Services 2.0 version here.

Continue reading...


 

Extending SSMS … January 4th, 2008

Vinod Kumar

Here is a nice article which shows how you can extend the SSMS IDE with your very own IDE. Read the article here.

Continue reading...