Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Article Of the Week

I really enjoy reading technical articles. They often enlighten me on new technologies or provide me with a new way to accomplish an old task. On most days I am inundated with new reading materials (Books, Magazines, Web Postings, Blog Postings, T-SQL Scripts, etc…) and it is often difficult to sift through it all and find the ones that are really worth reading. However, since I am working on my PhD and consider myself an educator, I have decided to read even more. As a result, I have decided to share one of my favorite articles from the past weeks readings with all of you hear in my blog. Some of the articles will be new and some will be older, but each article should provide someone with some type of information. So let’s get started.

The first article, in the many to come was published in the January 2008 MSDN magazine. Ian Stirk’s article, Uncover Hidden Date to Optimize Application Performance, highlights the many uses of Dynamic management views and functions. He provided the reader with several queries that would assist in solving various performance problems that can be traced back to poorly performing database queries. Several queries are given that can help DBAs identify Costly Queries by I/O and CPU, Fragmented Indexes, Missing Indexes, Queries Suffering from Blocking, and many more. If I had to choose my favorite query among the many I would have to say the one that helps to identify Missing Indexes by Database.

Go out and read the article when you have some time, especially if you are having some performance problems. Thanks Ian for a great article. Check back next week for another article.

URL to article: http://msdn.microsoft.com/en-us/magazine/cc135978.aspx?pr=blog

Talk to you soon

Patrick LeBlanc, Founder TSQLScripts.com

SQL Down South

Comments

Posted by Steve Jones on 24 August 2009

Thanks for the recommendation and it's good to hear what other people read. Did you find it here? We ran that one in Jan as a link.

Posted by Patrick LeBlanc on 24 August 2009

Actually I receive the print version of MSDN, I am so old school.  Read it on a flight to Dallas.

Leave a Comment

Please register or log in to leave a comment.