| Author |
Topic |
|
jamie
Aged Yak Warrior
542 Posts |
 Posted - 2004-06-22 : 07:44:25
|
| hi,I have a process runnig on my server, the T-SQL is :EXECUTE msdb.dbo.sp_sqlagent_get_perf_countersits running against the msbd database the Physical IO is 15588882 and CPU s 29111 .can anyone tell me about this process ?are the vaules anything to worry about ? |
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2004-06-22 : 07:55:11
|
| That is the SQL server agent fetching performance data, and populating the SYSPERFINFO table, I believe. Bear in mind that those numbers are cumulative since the start of the specific process. I am pretty certain that your SQLServer Agent is set to auto-start, so those number will be the totalusage since your SQL started, most likely.Having said the above, you COULD stop and start server agent to release those. There are times that I've done that, and it SEEMED to help, when resources were tight. If you aren't having any issues, I wouldn't worry.Do you have a regular shut-down and restart of your box ? They will get cleared down then, obviously.CiaO*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-06-22 : 07:59:10
|
| It is probably running for alerts you have setup on the SQL Server. If you go to Management..SQL Server Agent..Alerts, you will see a bunch of default alerts. To get rid of this running all the time, you can delete the demos and whatever else you have setup.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
jamie
Aged Yak Warrior
542 Posts |
Posted - 2004-06-22 : 08:04:10
|
| thanks for the info.maybe I should organise a server reboot on a weekly basis ?what do you think of that idea ?Its a win200 box with SQL7. |
|
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2004-06-22 : 08:07:26
|
| Hi Jamie - depends on your server guys feelings - I like the idea of every 1 to 2 weeks personally. Ask the more experienced guys for their views. As Derrick noted, you could remove unnecessary jobs and alerts etc. Good thinking (... runs off to check his server's :-) )CiaO*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-06-22 : 08:15:12
|
| You shouldn't have to reboot the server for this. Try disabling what you aren't using first. We only reboot our servers once a month. That's only if there is an update or SP we've already tested for a week in development, so sometimes we go several months without rebooting.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2004-06-22 : 08:28:00
|
| Derrick,You run windows server's for month's, and don't have any performance/virtual memory issues? Of course, perhaps your server's are prpperly dedicated to SQL server, in which case I guess the virtual memory is largely unused....The Windows admin's I know say that they like to recycle the boxes every 2 weeks or so (Nt and windows 2000 ... don't know about 2003). Of course, all of this assumes that you are able (i.e. not running intensive usage 24x7 systems)...If you had a windows for maintenance etc. on a regular basis, would you also use it, or do you prefer to let it stay up as long as possible? I'm interested to know ...*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-06-22 : 08:35:58
|
| My window for maintenance is once a month on a Thursday.The second Thursday night of each month, I install and test on dev.The third Thursday night of each month, I install and test on production.The boxes are mostly dedicated SQL Server boxes. I have 27 or so SQL Servers now though, so they aren't all dedicated. When I was on older equipment, I forced a reboot every two weeks. Now, there is not need to and we don't see any issues. All my boxes in the house are running the exact same service pack levels, etc though.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2004-06-22 : 10:09:46
|
| Nice to know ... perhaps I have an overly cautious/negative view on Windows virtual memory file mamagement, biased from my early days...Thanks for that*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
|
|
|
|
SQLAgent -Alert Engine