question

SQLRocker avatar image
0 Votes"
SQLRocker asked SQLRocker answered

How to run pssdiag on a single database?

Hi, I would like to run pssdiag on a single database using Diagmanager (instead of the whole instance), is it possible to do that?

Pretty much i would like to filter the profiler trace to be run only on 1 database... Just like if you just run sql profiler - you can filter and mention the database... I don't see a way to goto the 'Profiler Trace' tab of diagmanager and 'choose' a database...

Thanks.

sql-server-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AmeliaGu-msft avatar image
1 Vote"
AmeliaGu-msft answered

Hi SQLRocker,
It seems we cannot filter the database in pssdiag.
This tool seems to only collect data for the entire instance.

Best Regards,
Amelia


If the answer is helpful, please click "Accept Answer" and upvote it.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

SQLRocker avatar image
0 Votes"
SQLRocker answered

Ok, thanks, would be nice to have that option as some instances have large # of abs.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.