Q
Problem solve Get help with specific problems with your technologies, process and projects.

Waiting for SQL Profiler 7.0

Find out how long you would have to wait for the SQL Server 7.0 Profiler to run to gather "valid, meaningful" statistics?

I am using SQL Server 7.0 and was curious how long should I allow the profiler to run to gather "valid, meaningful" statistics -- 1 day, 1 week?
All you really need is one day's worth of information, but make sure you collect the information on a day when the server is getting a pretty good work out from the users. You don't want to collect data during the off hours or on a weekend day.

 


Do you have comments on this Ask the Expert Q&A? Let us know.

Dig Deeper on Microsoft SQL Server Installation

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close