Performance Has Changed To Performance Moniter

TheNew7

New member
I am going through sql server 2005 implemetation and maintenance book.

On chapter 15 it is going through useing performance moniter. which was about long before windows 7.

Now ive got up to specifying my counters but i cannot find options to:

1. Set the inteval to one second.
2. Specify which user to run counter logs and enter the users password
3. Leave the log files and schedules tabs at their defaults - (dont even know what this means)

Any ideas how to do these?

Thanks.
 

My Computer

Computer Manufacturer/Model Number
Toshiba
OS
Windows 7
I am going through sql server 2005 implemetation and maintenance book.

On chapter 15 it is going through useing performance moniter. which was about long before windows 7.

Now ive got up to specifying my counters but i cannot find options to:

1. Set the inteval to one second.
2. Specify which user to run counter logs and enter the users password
3. Leave the log files and schedules tabs at their defaults - (dont even know what this means)

Any ideas how to do these?

Thanks.

In Reliability and Performance Monitor, Click on Performance Monitor ont he left pane, then right click it and "New" > "Data Collector Set". Run through the Wizard, here you can give a name and set the user to run as and enter the password. You will hen see it under "Data Colector Sets" ion the left pane, you can right click go to properties to see the other settings.
 

My Computer

OS
Windows 7
CPU
i5-750
Motherboard
Asus
Memory
4GB DDR3 1600
Graphics Card(s)
GT220
I set up some performance counters using the data collector wizard to monitor paging activity on my computer. Attached are the results.
 

Attachments

  • Capture.jpg
    Capture.jpg
    194.3 KB · Views: 21
  • Capture1.jpg
    Capture1.jpg
    148.6 KB · Views: 14

My Computer

OS
Windows 7
Thanks.

I cant work i set it up and added the interfalls but i cant work out how to add a user.

and also is it asking for a sql user (login) or a windows user.

Thanks.
 

My Computer

Computer Manufacturer/Model Number
Toshiba
OS
Windows 7
Type perfmon in the search area of the start menu, then click it at top.

Right click user defined to create new data collector set.

The wizard will guide you through the process.
 

Attachments

  • Capture9.jpg
    Capture9.jpg
    111.5 KB · Views: 12
  • Capture8 - Copy.jpg
    Capture8 - Copy.jpg
    151.5 KB · Views: 13
  • Capture7 - Copy.jpg
    Capture7 - Copy.jpg
    150.1 KB · Views: 11
  • Capture6 - Copy.jpg
    Capture6 - Copy.jpg
    157.2 KB · Views: 13
  • Capture5 - Copy.jpg
    Capture5 - Copy.jpg
    189.5 KB · Views: 16
  • Capture4 - Copy.jpg
    Capture4 - Copy.jpg
    152.5 KB · Views: 14
  • Capture3 - Copy.jpg
    Capture3 - Copy.jpg
    152.1 KB · Views: 15
  • Capture1 - Copy.jpg
    Capture1 - Copy.jpg
    156.5 KB · Views: 13
  • Capture.jpg
    Capture.jpg
    48.6 KB · Views: 14
  • Capture10.jpg
    Capture10.jpg
    170.8 KB · Views: 13
Last edited:

My Computer

OS
Windows 7
Back
Top