casinos

Archive for January, 2008

SQL Counter: Part 1 (Processor Time) January 3rd, 2008

Vinod Kumar

In the SQL Counters series I will talk about one counter eachtime. Like, learn a counter a day and keep all headaches away :) … Counters are very helpful in finding the health of your server and give you great insight to where a potential problem is. Though not exhaustive, here is an initial list that you can learn about.

Process Object -> % Processor Time
The measurement is the amount of time that the server is executing a nonidle thread. This counter provides an indication of a possible bottleneck. A server will go to 100% CPU at times, but unless this is sustained for a period of time (for example, 5 minutes or so), it is usually nothing to worry about. However, over time, for example, a month, if the CPUs are averaging constantly more than 50%, it might be a good idea to start planning for an upgrade. If processors are averaging constantly greater than 70%, then it might be time to hurry that planning along.

Since this is the first post, get the list of my top 25 counters to monitor on my site here

Continue reading...


 

SQL Code formatter !!! January 3rd, 2008

Vinod Kumar

This is reall kewl !!! Check it out here … Really handy for people who write online articles …

Continue reading...


 

New on ExtremeExperts !!! January 2nd, 2008

Vinod Kumar

With our website hitting 2 Mil Page views, I am all geared to upload as many articles as possible on my website this year. And this year is special with SQL 2008 :) …

 So here you go, first article for this year – Archiving Data with SQL Server 2005.

Asusal, feedbacks welcome !!!

Continue reading...


 

SQL Server Tools !!! January 2nd, 2008

Vinod Kumar

Mladen has a cool list of tools that can be used with SQL Server 2005. Check the post here.

Continue reading...


 

Happy New Year 2008 !!! January 1st, 2008

Vinod Kumar

Wishing all you folks a happy and prosperous new year. Will promise to increase the activities over the blog and my website …

With SQL Server 2008 to be released this year … There will be a lot to write …

Continue reading...