How many total select statements for a specific web page?
I was wondering what the easiest way is to see the total number of database requests from my ASP.Net (.NET 2.0) application.
My application makes heavy use of sql 2005 database because all data is dynamic and everything goes through one connection string in web.config. Connection pooling enabled.
So, I am wondering how many select statements are executed for a particular page that I load in my browser.
I don't care if I can see this information from the .net side or from the db side as long as I only see connections to the MY database. Not all connections to this db server because I am using a shared db server and there are many other databases.
The best way to do this is to set up a profiler in your database and then make one request to your ASP.NET application.The profiler will collect any data you want and you can use that data to determine which queries were sent to SQL Server from your application.
a source to share
The SQL Server Profiler will list all the actions performed on your database. If you are using a different db login for your project (it might be a really good idea if you haven't), you can filter to only display actions from your login (see Selecting Events, Column Filters. "Login name").
a source to share
If you have a database tier in your code, you can change it to write a log message every time you run a select statement. Then just load the page once and count the number of log statements. This may or may not work depending on how your code is structured, but that's an option.
Edit: I misunderstood the question. I thought you had multiple clients connecting to the same database, not the same database server. In this case, a profiler is probably the best choice.
a source to share