October 29, 2010 at 4:58 am
Hello,
Is it only possible to run a trace on one database at a time? If I have an instance with 5 databases in, do I have to run 5 traces? My aim is to run the trace files against DB's in a test environment, but the databases are in different instances and the instances themselves have new names.
Any advice on this, or a better way to test would be most appreciated.
Thank you.
Regards,
D.
October 29, 2010 at 5:04 am
Duran (10/29/2010)
Hello,Is it only possible to run a trace on one database at a time?
You can filter you re trace to a certain database
If I have an instance with 5 databases in, do I have to run 5 traces?
Trace is for an instance, filter on db's
My aim is to run the trace files against DB's in a test environment, but the databases are in different instances and the instances themselves have new names.
this contradicts the previous question where you have an instance with 5 db's. But the answer is the same Trace is for over an instance
October 29, 2010 at 6:56 am
Yep, Marco has nailed it. A trace runs on an instance. You can filter the trace.
I'm a bit confused over what you're trying to do. You talk about all databases on an instance and then different databases on different instances. What are you attempting to monitor? What metrics are you trying to collect?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 29, 2010 at 7:32 am
Hey,
Thank you for getting back. All I want to do is put the databases under a similar stress as they are day to day so see if the hardware manages ok.
Regards,
D.
October 29, 2010 at 7:49 am
you want to "replay" the trace
http://msdn.microsoft.com/en-us/library/ms189604.aspx
check also out the requirement
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply