March 20, 2008 at 11:13 am
Hey all,
Before I get underway with writing my own process, I'm sure this has been down over and over and probably better than what I'd come up with anyways. Anyone have any links to some freeware apps and/or scripts that could help me capture specific perfmon events into a table?
Thanks
March 20, 2008 at 12:06 pm
I downloaded and installed the performance collector as well, yet I still don't have the service in my services list?
Regardless, not sure If this is what I'm looking for ... at first glance, it doesn't appear that it allows for customization of the counters I want, this looks to be all the SQL counters when I'm more concerned about some of the os counters.
March 20, 2008 at 12:08 pm
I would not recommend it, but you can log directly into a SQL Server database.
Instead, I've logged out the CSV's and imported them directly to a table inside the database of choice. Nice & easy.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 20, 2008 at 12:11 pm
Sorry, left out a bit of detail.
Instead of looking at the System Monitor, go to the Performance Logs and Alerts and set up a new Counter Logs using the "New Log Settings..." menu choice. That's where you can set up the counters for one more SQL Servers, OS, whatever, and output to a file (or a database), whose format you can pick.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 20, 2008 at 12:14 pm
Grant Fritchey (3/20/2008)
Sorry, left out a bit of detail.Instead of looking at the System Monitor, go to the Performance Logs and Alerts and set up a new Counter Logs using the "New Log Settings..." menu choice. That's where you can set up the counters for one more SQL Servers, OS, whatever, and output to a file (or a database), whose format you can pick.
Yeah this was the original choice I was going to go with ... just feeling lazy and didn't feel like building the wrapper and normalizing the data for this as it seems like it would be quite a bit of data.
March 20, 2008 at 12:15 pm
The deployment guide in the PerfCollector folder shows how to modify that; SQLH2 V2 Perf Collector Deployment Guide.
Should be able to add the counters you want in H2PerfConfigFile.xml.
March 20, 2008 at 12:19 pm
Adam Bean (3/20/2008)
Grant Fritchey (3/20/2008)
Sorry, left out a bit of detail.Instead of looking at the System Monitor, go to the Performance Logs and Alerts and set up a new Counter Logs using the "New Log Settings..." menu choice. That's where you can set up the counters for one more SQL Servers, OS, whatever, and output to a file (or a database), whose format you can pick.
Yeah this was the original choice I was going to go with ... just feeling lazy and didn't feel like building the wrapper and normalizing the data for this as it seems like it would be quite a bit of data.
Oh, sorry. I guess I misunderstood.
Just buy Idera's monitoring product. It does all that plus collects Profiler data.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 20, 2008 at 12:21 pm
Yeah that would be nice ... but I think I'm just gonna have to bite the bullet and create a process ... was just hoping to find something someone already built.
March 20, 2008 at 1:12 pm
Look at Grant's idea about setting up a regular process in Perfmon that saves the results to csv. Then use the Relog tool to load that into a db. And as an afterthought, ALL the SQL counters in Perfmon can be found in the sys.sysperfinfo catalog view.
DAB
March 20, 2008 at 1:43 pm
The added value of having the perfmon files is that you can then link them up with Profiler files for some serious troubleshooting & tuning fun.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply