dbTalk Databases Forums  

DTS Performance Monitor Values to a table

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss DTS Performance Monitor Values to a table in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Pete
 
Posts: n/a

Default DTS Performance Monitor Values to a table - 06-22-2004 , 10:32 PM






My server operating system is Windows 2000 Advanced
server with SQL Server 2000 Enterprise.

I have about 30 performance counters that collects
samples every minute on the server. I would like to
automated a system that will copy the values to a SQL
Server database table daily.

Please help me with task.

Thanks,

Pete


Reply With Quote
  #2  
Old   
Andrew J. Kelly
 
Posts: n/a

Default Re: DTS Performance Monitor Values to a table - 06-23-2004 , 07:24 AM






Take a look at the relog.exe utility that is available with XP and the 2000
resource kit. It will allow you to place the counters into several
normalized tables with just a single command.

--
Andrew J. Kelly SQL MVP


"Pete" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:
My server operating system is Windows 2000 Advanced
server with SQL Server 2000 Enterprise.

I have about 30 performance counters that collects
samples every minute on the server. I would like to
automated a system that will copy the values to a SQL
Server database table daily.

Please help me with task.

Thanks,

Pete




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.