Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 SQL Profile for the Database

Author  Topic 

TMDOSS
Starting Member

33 Posts

Posted - 2010-03-09 : 11:18:12
I need to do Profile for our test database.
How can and where I need to add database name
Pl help

Bustaz Kool
Master Smack Fu Yak Hacker

1834 Posts

Posted - 2010-03-09 : 19:23:46
I am assuming that you want to limit the Profile to only that one database:

Under Trace Properties - Events Selection tab - Column Filter you can specify a Database Name to filter by. If the Database Name is not present in that list, check the Show All Columns and make sure that Database Name is one of the columns that you will be displaying.

HTH

=======================================
Few things are harder to put up with than the annoyance of a good example. (Mark Twain)
Go to Top of Page
   

- Advertisement -