CODEWITHSUNDEEP
sql-server
StevieB
StevieB

Reputation: 6541

Using SQL Profiler can I pinpoint to one DB

Can I pinpoint SQL Profiler just to one Database, my server has around 50 Database and I just want SQL Profiler to check one Database because the site that uses that Database has gone very slow.

Upvotes: 1

Views: 102

Answers (1)

Andrew Carmichael
Andrew Carmichael

Reputation: 3113

Yes, you can.

When you set your trace up, go to the Events Selection tab and click the "Show all columns" checkbox. Then the Database column appears and you can put a filter on the database name in Column Filters.

Upvotes: 1

Related Questions