Regarding monitoring the database

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Regarding monitoring the database

Author

Topic

under2811
Constraint Violating Yak Guru

366 Posts

Posted - 2006-02-16 : 13:06:20

Hi..friends...

I am monitoring my databse..i set new counter log by adding objects like memory,disk,processer..sample data every 1 min interval....log file type sql database....but after certain time i got one file in C:\perflogs\file_name.blg...but i am wondering how to use this file and get monitor to my objects set???? where i will find that..pls help me out with details

T.I.A

Papillon

JoeNak
Constraint Violating Yak Guru

292 Posts

Posted - 2006-02-16 : 13:25:53

I believe you have to open the file (through perf mon) and review.

A better solution is to create an odbc from your server running perfmon to some SQL server and store the info in tables.

JoeNak
Constraint Violating Yak Guru

292 Posts

Posted - 2006-02-16 : 13:27:19

Take a look at this: http://www.sql-server-performance.com/gv_monitoring_8_steps.asp

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-02-16 : 13:41:10

I output my counter values into a CSV file from Performance Monitor. I can then easily import the CSV file using DTS or bcp for analysis within SQL Server. I prefer to do it within SQL Server as I can write my own queries against the results.

Tara Kizer
aka tduggan

under2811
Constraint Violating Yak Guru

366 Posts

Posted - 2006-02-16 : 14:28:02

hi..tara..i did what u suggest me from ur point of view i got csv file i import it into database..i have taken only memory as my key concern..i got these columns from my table..
Memory\Page Faults/sec
Memory\Available Bytes
Memory\Committed Bytes
Memory\Commit Limit
Memory\Write Copies/sec
Memory\Transition Faults/sec
Memory\Cache Faults/sec
Memory\Demand Zero Faults/sec
Memory\Pages/sec
Memory\Pages Input/sec
Memory\Page Reads/sec
Memory\Pages Output/sec
Memory\Pool Paged Bytes
Memory\Pool Nonpaged Bytes
Memory\Page Writes/sec
Memory\Pool Paged Allocs
Memory\Pool Nonpaged Allocs
Memory\Free System Page Table Entries
Memory\Cache Bytes
Memory\Cache Bytes Peak
Memory\Pool Paged Resident Bytes
Memory\System Code Total Bytes
Memory\System Code Resident Bytes
Memory\System Driver Total Bytes
Memory\System Driver Resident Bytes
Memory\System Cache Resident Bytes
Memory\% Committed Bytes In Use
Memory\Available KBytes
Memory\Available MBytes
Memory\Transition Pages RePurposed/sec

please now can you guide me what column i shud take to find Avg.memory utilization and total memory utilization....

T.I.A

Papillon

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-02-16 : 14:46:37

SELECT AVG(Memory\Available MBytes) --or whatever the column named
FROM YourTable

For SQL Server memory, I prefer to use SQLServerMemory Manager:Target Server Memory(KB) and Total Server Memory(KB). These are specific to SQL Server and excludes other processes using memory on that server.

Tara Kizer
aka tduggan

under2811
Constraint Violating Yak Guru

366 Posts

Posted - 2006-02-16 : 15:05:02

Thanks tara.......

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources