Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Performance Monitors Start/Stop 7AM

 
   Database Forums (Home) -> Server RSS
Next:  using nvarchar  
Author Message
Dan J.

External


Since: Jun 30, 2004
Posts: 1



(Msg. 1) Posted: Wed Jun 30, 2004 5:57 am
Post subject: Performance Monitors Start/Stop 7AM
Archived from groups: microsoft>public>sqlserver>server (more info?)

I have Windows 2000 Advanced Server with SQL Server 2000
Enterprise with SP3A. I trying to set up a job to import
Performance Monitors daily into SQL Server table. How
would I set up Performance Monitor to stop at 7AM close
the present file, create a new file at 7:01AM start
collecting statistics.

This would be a very help to resolve this issue.

Thank You,

Dan J.

 >> Stay informed about: Performance Monitors Start/Stop 7AM 
Back to top
Login to vote
Andrew J. Kelly

External


Since: Sep 01, 2003
Posts: 975



(Msg. 2) Posted: Wed Jun 30, 2004 10:11 am
Post subject: Re: Performance Monitors Start/Stop 7AM [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

There are some utilities that come with Xp and I believe are in the resource
kit of Win2000 that should help. One is called logman.exe and the other is
relog.exe. Logman can allow you to create, start, stop, change etc your
perfmon traces and relog will import them into a sql server table.

<a style='text-decoration: underline;' href="http://www.microsoft.com/resources/documentation/windows/xp/all/proddocs/en-us/nt_command_logman.mspx" target="_blank">http://www.microsoft.com/resources/documentation/windows/xp/all/proddo...en-us/n</a>

<a style='text-decoration: underline;' href="http://www.microsoft.com/resources/documentation/windows/xp/all/proddocs/en-us/nt_command_relog.mspx" target="_blank">http://www.microsoft.com/resources/documentation/windows/xp/all/proddo...en-us/n</a>

--
Andrew J. Kelly SQL MVP


"Dan J." wrote in message

 >
 > I have Windows 2000 Advanced Server with SQL Server 2000
 > Enterprise with SP3A. I trying to set up a job to import
 > Performance Monitors daily into SQL Server table. How
 > would I set up Performance Monitor to stop at 7AM close
 > the present file, create a new file at 7:01AM start
 > collecting statistics.
 >
 > This would be a very help to resolve this issue.
 >
 > Thank You,
 >
 > Dan J.
 ><!-- ~MESSAGE_AFTER~ -->

 >> Stay informed about: Performance Monitors Start/Stop 7AM 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
performance monitors on the SQL 2005 - Looking to see if there is anyway to enable or capture or if already available query performance stats on SQL2005 we are having issues with one of our databases.. and the programmers say everything is ok.. ( they are outside verndors) So is there..

why the MS DTC always stop services automatically ? - why the MS DTC always stop services automatically ? hi , two sql server MS DTC services stop services automatically : one server : After my anti-virus software killed a vbs virus , MS DTC services stop services automatically in a minute, then..

how do i stop a maintenance plan? - I have a maintenance plan that runs every night. Sometimes it takes too long to run and it affects production for the following morning. I can see and kill the process it is currently running but then the next task starts and i have to kill that too....

Script to stop SQL server services and SQL instances. - What is the best way to write a scrip to Stop SQL Server service or SQL Instance servies. Thanks for the help.

Is it really needed to STOP SQL Service before reboot the .. - Is it really needed to STOP SQL Service before reboot the server? Based on the the value in the registry key HKLM\SYSTEM\CurrentControlSet\Control\WaitToKillServiceTimeout, the server can kill the process if it takes too long to stop. I think it's not...
   Database Forums (Home) -> Server All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]