A Technique for Determining the I/O Hog in your Database

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Michael Morin » A Technique for Determining the I/O Hog in...

22 posts, Page 3 of 3

«««1 2 3

A Technique for Determining the I/O Hog in your Database

Rate Topic

Display Mode

Topic Options

Author

Message

Mayank Khatri

Posted Tuesday, July 21, 2009 8:30 AM

SSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 11:43 AM
Points: 1,776, Visits: 1,442

The two Screen Shots are not getting displayed under "Analyze the Results" section. Is anyone else facing the same problem?

Post #756634

Mike Morin-219647

Posted Thursday, July 23, 2009 7:45 PM

Forum Newbie

Group: General Forum Members
Last Login: Yesterday @ 10:49 AM
Points: 5, Visits: 153

From the author, many years too late, but still worth commenting on: Yes, indeed sharp readers, the aggregate clause in "Summarize the Data" shoud be "count(*)" and not "sum(*)"! I still do not know how I let that slip through! Many thanks to you for catching that and passing along. To all, I've enjoyed your comments and I especially appreciate those who have taken this a step beyond (or many more steps). That is precisely what I had hoped to accomplish with this article: to give folks a starting point that they could utilize in their own work. Now that we have SQL Server 2005, the included system views take care of a lot of this, but it is still useful for anyone who is still running SQL Server 2000.

Post #758760

« Prev Topic | Next Topic »

22 posts, Page 3 of 3

«««1 2 3

Permissions