October 21, 2005 07:21 PM

Troubleshooting Performance Problems

Rating: (0)
SQL Server Magazine
InstantDoc ID #48181

I have two servers, Production and Development, that are identical in hardware and setup, although the execution plans are different. A query that I run on the Production server takes 3 seconds to complete; the same query on the Development server takes 66 seconds! I've tried everything I can think of to troubleshoot the slowdown, including using DBCC INDEXDEFRAG, DBCC DBREINDEX, and DBCC SHOWCONTIG. Please advise.

...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Add a Comment

There are no comments to display. Be the first one!
You must log on before posting a comment.

Are you a new visitor? Register Here
GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS