Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Analyzing Data Storage - Ten SHOWCONTIG Queries Expand / Collapse
Author
Message
Posted Monday, July 12, 2004 3:43 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, May 11, 2011 5:16 AM
Points: 24, Visits: 51
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/colu


Post #125957
Posted Monday, August 16, 2004 9:00 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, March 26, 2010 7:51 AM
Points: 269, Visits: 8

Excellent!  I am currently evaluating a restucturing of our database and this really opened my eyes to some shocking things.  Thanks!




Post #132038
Posted Monday, August 16, 2004 10:40 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, March 11, 2014 2:39 PM
Points: 216, Visits: 422
This is a great article. One of those articles that will nudge a DBA like myself into looking at this info for our databases. Thanks for the great work!


Rick Todd
Post #132071
Posted Monday, August 16, 2004 5:18 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 2:01 AM
Points: 2,693, Visits: 1,173
Nice article.

Only thing I would change is using a permanent table instead of a temporary one.

Then you can accumulate the data and perform some analysis on it.



Hope this helps
Phill Carter
--------------------
Colt 45 - the original point and click interface

Australian SQL Server User Groups - My profile
Phills Philosophies
Murrumbeena Cricket Club
Post #132135
Posted Monday, August 16, 2004 7:46 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, July 31, 2007 8:20 AM
Points: 885, Visits: 1

Hi there

Great article, simple solution and very easy to extend.

Thanks

Cheers

Chris K




Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
Post #132145
Posted Tuesday, August 16, 2005 9:45 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 11:17 AM
Points: 95, Visits: 436

Great Article.  I've been investigating performance issues and using SHOWCONTIG.  I'm going to use these queries.  Thanks.  bblack

Post #210894
Posted Thursday, February 16, 2006 4:09 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, July 29, 2009 10:04 AM
Points: 7, Visits: 2
Thanks a lot for this great article.  I am investigating some performance issues and this is a big help.
Post #259241
Posted Wednesday, September 26, 2007 11:52 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, October 15, 2007 5:21 PM
Points: 14, Visits: 11
Excellent article.

I want to ask why sometimes, we have rows where indexename is empty?
Thanks
Post #403155
Posted Tuesday, June 16, 2009 8:12 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 7:12 AM
Points: 1,082, Visits: 4,888
Just what I was looking for - most useful.
Thanks
Post #735686
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse