You are a database administrator for your company.
The company stores all its business information in adatabase named Prod1 residing on a SQL Server instance Srv1, which in turn resides on the Sql1 computer.
The Prod1 database is 35 GB in size and occupies almost 90 percent of the hard disk space allocated to Sql1.
Another SQL Server instance Srv2 , located on server computer Sql2 is configured as a linked server on Srv1.
You manage the Prod1 database. To improve query performance and optimize indexes, queries and stored procedures, you frequently run traces using SQL Server Profiler.
The trace information is accessed by other teammembers using Transact-SQL queries.
When you run SQL Server Profiler, other team members complain that theperformance of Srv1 is adversely affected.
You want to ensure that when you run SQL Server Profiler, the performance of the Prod1 database is not affected.
What should you do?