SQL Server - Ways to capture Performance Monitor data - Feb
27, 2010 at 11:50 AM by Shuchi Gauri
Explain the ways to capture Performance Monitor data for review purpose.
Ways to capture performance monitor data:
-
Create a perfmon log file using Control Panel -> Administrative tools ->
Performance. Choose counters to monitor.
-
Start SQL Profiler and go to File->New Trace. Choose the server to be
monitored. Set Trace properties.
-
Combine perfmon log file and SQL Server Trace file.
-
Take the perfmon logs, export them to ASCII and then import them into SQL
Server database. Before performing analysis, export them to excel.
-
Use third party tools to collect, store and show data.
SQL Server - Ways to capture Performance Monitor data - May
05, 2009 at 22:00 PM by Rajmeet Ghai
Explain the ways to capture Performance Monitor data for review purpose.
-
One of the cheapest ways to capture performance monitor data is to use
performance monitor itself. The performance monitor can be used to create logs
of each activity. Activities of different instances of performance monitor can
also be done for comparison. This option is not suitable to make a variety of
reports or when flexibility is desired.
-
The above collected logs can also be exported them to an ASCII format and then
import them into an SQL server database for a deeper analysis.
-
For a better reporting and data collection, a third party tool can be used to
collect, store and display the data.
SQL Server - Ways to capture Performance Monitor data - June
21, 2009 at 09:00 AM by Amit Satpute
Explain the ways to capture Performance Monitor data for review purpose.
-
Use Performance Monitor (System Monitor) to capture relevant Performance
Monitor data and then save it in the form of Performance Monitor logs.
This option is cheap but is not very flexible.
-
The logs collected by performance Monitor can also be taken and imported into
an SQL Server database after converting them to ASCII. After that analysis can
be done using the MS Excel.
It involves a lot of work, but it is very flexible and can produce projections
and graphs.
-
A third-party program can be used to collect, store, and display the data.
In this option, the tool needs to be set up just once. The Performance Monitor
data is automatically collected for all of your SQL Servers and stored in a SQL
Server database. Reports can be produced with ease but the initial investment
is higher.
Also read
Answer - Stored procedures provide performance benefits through
local storage, precompiling the code, and caching......
Answer - CUBE generates a result set that represents aggregates
for all combinations of values in the selected columns.......
Answer - While importing data, the destination table must
already exist......
|
