1
vote
1answer
42 views

How to profile which SQL server a .NET application tries to connect

We have a huge .NET application from 3rd party that would be time consuming to disassemble and understand the code. It is compiled in Release mode. Connection strings to the MS SQL databases are ...
1
vote
1answer
610 views

Unexplained CPU and Disk activity spikes in SQL Server 2005

Before I pose my question, please allow me to describe the situation. I have a database server, with a number of tables. Two of the biggest tables contain over 800k rows each. The majority of rows ...
0
votes
2answers
1k views

SQL Server: Index utilization statistics?

Is there a way in SQL Server to get a report of index usage? i know starting with SQL Server 2005, you can get reports of top resource-using queries, based on what's in the Plan Cache: i'm curious ...
3
votes
4answers
221 views

“Catch All” Server-Side Load Profiling

If I have an infrastructure with some Web Servers (Windows 2003 and IIS) and a Database (SQL Server 2005) and ASP.net, I wonder if there is a catch-all tool that simply allows me to say "Ok, I now ...