On the server at issue, search for "Performance Monitor" and run it.
In the menu on the left, expand Data Collector Sets and select User Defined.
Right-click on User Defined and select New -> Data Collector Set from the popup menu.
In the Create New Data Collector Set dialog, provide a name to the data collector set and select Create Manually (Advanced). Click Next.
Select Create data logs ->Performance Counter. Click Next.
Note that Sample interval is set to 15 seconds. This means a sample of counter data will be logged every 15 seconds. We typically run a Data Collector Set for at least 1 day, so a larger value from 5 to 15 minutes is more appropriate. Set this value now.
Click Add...
Counters are grouped into Objects. Either you can monitor the whole object or selected instances from the object. For example, to monitor available RAM for the server expand Memory object, then select Available MBytes from the instances of selected object and click Add >>.
Here is an example list of counters we recommend for the DSP application server
Memory: Available MBytes
Memory: Pages/sec
Network Interface: Bytes Total/Sec
PhysicalDisk(each disk): % Disk Read Time
PhysicalDisk(each disk): % Disk Write Time
PhysicalDisk(<All instances>): % Idle Time
PhysicalDisk(each disk): Avg. Disk Queue Length
Process(w3wp): % Processor Time
Process(w3wp): Handle Count
Process(w3wp): Private Bytes
Process(w3wp): Virtual Bytes
Process(cranberryservice64): % Processor Time
Process(cranberryservice64): Private Bytes
Process(cranberryservice64): Virtual Bytes
Processor(_Total): % Processor Time
Here is an example list of counters we recommend for the DSP database server
Memory: Available MBytes
Memory: Pages/sec
Network Interface: Bytes Total/Sec
PhysicalDisk(each disk): % Disk Read Time
PhysicalDisk(each disk): % Disk Write Time
PhysicalDisk(<All instances>): % Idle Time
PhysicalDisk(each disk): Avg. Disk Queue Length
Process(sqlserver): % Processor Time
Processor(_Total): % Processor Time
SQL Server Access Methods: Full Scans/Sec
SQL Server Buffer Manager: Buffer Cache Hit Ratio
SQL Server Buffer Manager: Cache Size (pages)
SQL Server Locks: Average Wait Time
SQL Server SQL Statistics: Batch Requests/Sec
SQL Server SQL Statistics: SQL Compilations/Sec counter
System: Processor Queue Length
Click OK..
Provide the file path where you want to save the data.
Take note of the file path that is chosen for this data collector set. Some folders containing .blg files will be generated there after the data collector set has been started. The most recent .blg file is what you can attach to a ticket (assuming the data collector set had been running when the issue being investigated has appeared).
Click Next.
Select Save and Close. Click Finish.
Starting a Data Collector Set
On the server at issue, search for "Performance Monitor" and run it.
In the menu on the left, expand Data Collector Sets and select User Defined.
In the space on the right, right-click on your desired data collector set under and select Start from the popup menu.
Or you can schedule it to start at a specified time. To do this, right-click on the data collector set under and select Properties from the popup menu. In the Properties dialog, select Schedule. Click Add. Select beginning date, expiration date, and start time. Click OK.
Stopping a Data Collector Set
On the server at issue, search for "Performance Monitor" and run it.
In the menu on the left, expand Data Collector Sets and select User Defined.
In the space on the right, right-click on your desired data collector set under and select Stop from the popup menu.
Or you can specify a stop condition. It can be after certain hours/days etc. To do this, right-click on the data collector set and select Properties from the popup menu. Go to Stop condition. Specify the duration and unit. Say you set overall duration as 5 and unit as hours. This means, once the data collector is started, it will automatically stop after 5 hours. You can also set a limit on the data collector set to rollover or restart after a certain duration or after a maximum size is reached.
