January 25, 2006 01:25 PM

Winning the Fragmentation Battle

How one DBA tracked down—and fixed—the cause of creeping database performance
Rating: (0)
SQL Server Magazine
InstantDoc ID #48914
A few months ago, I was awakened to the insistent buzzing and chirping of my BlackBerry telling me I had a high-priority message. All the customers who used one of my databases were calling in complaining that our Web application was taking 20 to 30 seconds to load the pages they used the most. Performance had gradually worsened over the prior few weeks and was now at the point where just a few more people logging in would bring the system down. I had to find the source of the problem—and ...

You must be a paid Professional Member to access this entire article.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Monthly or Annual

Professional Membership

VIP Membership

Compare Member Benefits

Add a Comment

Now I have to check my db's. :) Good article.

DAVID3/8/2009 12:40:51 PM


I apologize for the incomplete zip file--we inadvertently left out the nonpublished stored procedures but are adding those to the 48914.zip download file. It should be updated with the complete files shortly. --Anne Grubb, senior editor

Anne5/30/2006 12:17:25 PM


Wondering if Author/editors ever read those comments?? If yes, then where is the whole Stored Proc???

CAROLYN3/2/2006 8:30:42 AM


So much for really wanting to help us!

Robert2/14/2006 8:46:54 AM


Do I really have to buy a different magazine to get the code for the artical in this magazine! That is extortion! That`s like Micrsoft holding back on knowledge base articals for Windows XP until I buy Office!

Robert2/14/2006 8:39:23 AM


I agree with the statements above, article is incomplete to the point of frustration. Seems like Bait and Switch.

Boris2/8/2006 8:03:19 PM


Good article, it seems like a scam that I need to subscribe to Windows IT Pro to get the full SQL code when I am already a SQL Server Magazine subscriber.

Marc2/7/2006 3:57:13 PM


Enjoyed the article and got some great tips, but would appreciate the full stored procedure listing.

Leigh2/3/2006 1:56:29 AM


Good article, but without some of the SProcs/scripts for access it doesn't seem to help get a DBA started.

ROB1/28/2006 2:42:07 PM


How about all the code in the download area for the stored proc's instead of just snips? Let's make DBA even more productive and not make the fill in the blanks.

WILLIAM1/27/2006 11:48:19 AM


You must log on before posting a comment.

Are you a new visitor? Register Here

Rename Virtual Server (Cluster)

I am going to rename a clustered instance (default).1. Change SQL Network Name2. Take offline3. Bring online4. Flush DNS, Cache5. Test failover6. Rebu...222-96209

GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS