Performance Tunning Part 2

After checking on the net found that there are lots of lots of good stuff (queries) already describe the performance related information, so I would like the share and refer some of the very good site.

I have already blog about dmv’s here ,

Weasel Clause has written a great blog on queries which everyone should keep handy :

Here Weasel shows five queries

1. expensive queries:

2. wait stats

3. virtual file stats

4. plan cache interrogation

5. real-time blockers

Thanks Weasel Clause

Also another expert Glenn Berry’s wrote a series of statements to check the query here.

Thanks Glenn.

* The dmv’s will be good until your system up time or until not manually clear


And perform counter:

I have already blog more about tools and performance counter in my earlier blog here and here.

This entry was posted in DMV, Lock/Blocking, Performance Tuning, Whitepapers and tagged , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s