How do I view executed queries within SQL Server Management Studio?

ssms sql-server-express
bsh152s picture bsh152s · Mar 15, 2010 · Viewed 148.1k times · Source

I am new to SQL Server Management Studio and am wondering: is there is a way to see which queries have been run against a database?

In the Activity monitor, there is a "Recent Expensive Queries" report but I'm guessing that isn't all of the queries since I'm not seeing the ones I have run.

I am running SQL Server Express 2008 v 10.0.1600.22.

Answer

Benjamin Ortuzar picture Benjamin Ortuzar · Mar 15, 2010

Use SQL Profiler and use a filter on it to get the most expensive queries.

Related questions

How to set (combine) two primary keys in a table

For a small sales related application, we designed database using logical data model. Come to the stage to convert in to physical model. While creating table in SQL Server Management Studio Express, according to our logical data model, we need …

Read More
SQL Server: enable remote connections without SSMS

I've got a SQL Server Express 2008 install on my web server, which by default does not allow remote connections (probably a good thing.) I opted not to install SQL Server Management Studio Express along with it for disk space and …

Read More
SQL Server Management Studio Express 2005 has no Configuration Manager

Where is the configuration manager for SQL Express 2005? I need to configure SQL Server for TCP/IP but there is no configuration manager with the package. I see SQL Server Database Publishing Wizard, I see SQL Server Migration Assistant for …

Read More