Can I Use ANTS to debug SQL Server Management Studio?

Code and memory profiling for .NET developers.

Can I Use ANTS to debug SQL Server Management Studio?

Postby tadrichard » Mon Jan 12, 2009 3:25 pm

Here's a problem/question that I think should be right up your alley:

A few months ago, my SQL Server Management Studio 2005 (the client software, not the server) decided that it would like to randomly just go off on holiday and suck up all CPU cycles for no apparent reason. No network access/no memory changes -- just looping merrily along... This happens each and every time I run it, so is easily reproduceable.

This occurs after about the third or fourth query window is open; regardless of whether I'm running SQL server or any other software on the same machnine. It's gotten so bad that I've reduced myself to copying the query code into notepad after each query and trying to use the same query window over and over.

I'm running it on a laptop with 2GB of memory, about half of which is left unused, and there is no apparrent disk thrashing with the page file.

Searching the net, this problem seems to be occurring for many people, but the only reported solution I can find is to update the display drivers (? -- which I tried to no avail.)

Question 1: Has anyone else on this forum run into this and found a solution? I've tried performing a full removal and reinstall, but no help there.

Question 2: I'm wondering if I could somehow use ANTS to see where in the code Management Studio is cycling? It's my understanding that Management Studio is a .NET app; but I have little to no experience using ANTS. Could this be helpful?


Tad Richard
Posts: 2
Joined: Sat Jan 10, 2009 12:49 am

Postby Brian Donahue » Wed Jan 14, 2009 5:55 pm


You could profile SqlWb.exe, for instance, if you wanted to check the performance of a managed-code add-in for Management Studio. I don't think, however, that the core functionality of Management Studio is based in .NET, and at any rate, it would probably be difficult or impossible to fix without the source code to Management Studio.
Brian Donahue
Posts: 6590
Joined: Mon Aug 23, 2004 9:48 am

Return to ANTS Profiler Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests