Calendar
| S | M | T | W | T | F | S |
|---|---|---|---|---|---|---|
| « Feb | Apr » | |||||
| 1 | ||||||
| 2 | 3 | 4 | 5 | 6 | 7 | 8 |
| 9 | 10 | 11 | 12 | 13 | 14 | 15 |
| 16 | 17 | 18 | 19 | 20 | 21 | 22 |
| 23 | 24 | 25 | 26 | 27 | 28 | 29 |
| 30 | 31 | |||||
Categories
- IIS (1)
- Open Source (1)
- Performance (4)
- Personal (3)
- Powershell (1)
- SQL (1)
- SQL Server (21)
- T-SQL (15)
- Uncategorized (6)
- Utilities (5)
- Windows OS (14)
Latest Postings
- 14. April 2011: Deduplicating files with LogParser and SQL Server
- 25. February 2011: The final voyage of the USNS H. H. Hess
- 16. February 2011: Free SQL Server training videos
- 23. August 2010: Alert for long-running SQL datbase backups
- 7. April 2010: Learning SMO & Powershell
- 25. February 2010: SQL Generators for moving database files
- 28. January 2010: Index to Filegroup mapping
- 20. January 2010: PowerShell Script to Clean Up Old Files Based on Age
- 7. January 2010: Quick & Dirty way to identify orphan files
- 29. July 2009: Trigger Mass Enable / Disable
Links
Archives
- April 2011
- February 2011
- August 2010
- April 2010
- February 2010
- January 2010
- July 2009
- June 2009
- February 2009
- January 2009
- December 2008
- November 2008
- October 2008
- August 2008
- June 2008
- May 2008
- April 2008
- March 2008
- February 2008
- January 2008
- December 2007
- October 2007
- September 2007
- May 2007
- April 2007
- February 2007
Starting Windows Performance Logging at boot time
Performance logging will not start on its own at boot time. Here’s how to get around that problem.
-
Applies to: W2k3, XP
- Using the Performance MMC, create a set of counter logs.
- Use a specific name to save the settings, e.g., SQLPERF.
- At the command prompt, try starting and stopping performance logging using the logman.exe utility:
- logman start sqlperf
- logman stop sqlperf
- Set the Windows registry to automatically start performance counters at system startup
- Open the Registry Editor, regedit.exe.
- Navigate to HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Run
- Add a string value. A good name would be logman.
- Set the value equal to logman start sqlperf (or the command in step 4.a. that successfully started performance logging).
References: