mssql monitoring?

[dratliff]

Joseph,

Have you tried an older client? I have reverted back to the 1.1.7 agent.

Just a thought.

[claytronic]

Joseph,

I have not tested the SQL commands with the 1.4.x agent series. We are still running 1.1.7 in production. I'll post our results when we begin evaluating on our tier 2 production servers.

--
Claytronic

[tronite]

Well ... I would update my database and search on the host for anything to do with mssql monitoring?

Sorry if that's not much help!

[tronite]

I thought I already posted on this list, must have gotten side tracked, but I had wanted to ask what happens if you just locate what you are looking for and grep for the specifics?

[mrogers]

MS SQL Server Monitoring

Clay,
Would you mind kind of explaining the different parts of the query you wrote. I understand the UserParam and the key and a few other pieces however i am not familiar with all the switches. I'm kind of new to DB monitoring and would appreciate the help.

Thanks,

Matt

[claytronic]

Clay,
Would you mind kind of explaining the different parts of the query you wrote. I understand the UserParam and the key and a few other pieces however i am not familiar with all the switches. I'm kind of new to DB monitoring and would appreciate the help.

Thanks,

Matt

Matt,

The MS SQL performance counters that I previous posted are the basic gages for monitoring the health of a your SQL server. The are quite a few more that the ones that I use so take some time to identify what is important to your applications.

Here's a general explanation of each:

• \SQLServer:Buffer Manager()\Database pages Gages how often the SQL server can perform a transaction without having to perform disk I/O.
• \SQLServeratabases(DATABASE_NAME)\Data File(s) Size (KB) Measure of how large a particular database is physically growing
• \SQLServeratabases(DATABASE_NAME)\Log File(s) Size (KB) The physical size of the SQL transaction log. This one is very important since by default a SQL server will not automatically truncate the database log. If someone performs large update or deletes this log file can grow very quickly. Use this in conjunction with your disk space triggers.
• \SQLServer:General Statistics()\User Connections This shows how many concurrent connections are utilizing the SQL server itself. A sudden rise in these may point to a hung application that isn't properly closing connections. A .Net application SQL connection pool can often spike the connection count when a transaction has caused a large number of table locks.
• \SQLServer:Memory Manager()\Total Server Memory (KB) How much OS memory the SQL service is using.
• \Process(sqlservr)\% Processor Time Tracks how hard the SQL process is working. This is a great way to identify performance bottlenecks before they become big pains in your neck.
• \SQLServer:Locks(_Total)\Number of Deadlocks/sec If you see these happening then check with your DBA or application engineer because deadlocks are a SQL performance killer.
• \SQLServer:Locks(_Total)\Lock Waits/sec This measures how much time the database is having to wait to deliver its data because of other transactions locking tables.

Hope this helps.

--
Clayton

[clubbing80s]

Hi
I'm running zabbix-agent 1.4.2 on windows 2003 server with msql sql server 2005

I keep getting not supported .. i have tried adding an removing "()" etc .. what is that exact correct syntax for the following ?

PerfCounter = db_pages,"\SQLServer:Buffer Manager()\Database pages",60

PerfCounter = db_free_pages,"\SQLServer:Buffer Manager()\Free pages",60

PerfCounter = db_data_file_size,"\SQLServeratabases(BTD)\Data File(s) Size (KB)",60

PerfCounter = db_log_file_size,"\SQLServeratabases(BTD)\Log File(s) Size (KB)",60

PerfCounter = db_userconns,"\SQLServer:General Statistics()\User Connections",60

PerfCounter = db_server_mem(),"\SQLServer:Memory Manager()\Total Server Memory (KB)",60

PerfCounter = db_cpu_load(),"\Process(sqlservr)\% Processor Time",60

[swaterhouse]

Since you are on 1.4 you can add perf counters to the web interface without adding them to the config file on the agent.

type: Zabbix agent
key: perf_counter["\SQLServer:Buffer Manager\Database pages"]
Type of information: float



I started to put together a template for SQL on Friday. I have a couple of more things to add to it and I will post it to the wiki when complete.

[clubbing80s]

Thanks was a quick response .. many thanks, look forward to seeing your template ..
G

[clubbing80s]

ok winning with most but the following are still not behaving ..

perf_counter["\SQLServer:_Databases(WEBCOLTECH\Data File(s) Size (KB)"]
perf_counter["\SQLServer:_Databases(WEBCOLTECH)\Log File(s) Size (KB)"]
where WEBCOLTECH is the database name (what if i wanted the total foot print of all the databases ?)

still getting not supported what have i missed
Thanks for you time ..
G

[claytronic]

Since you are on 1.4 you can add perf counters to the web interface without adding them to the config file on the agent.

I like your idea of moving all of the perfmon counters into the database. Having everything in a template would save a bunch of time and centralize the configuration. Is there any 1.4 / 1.6 Win32 Agent differences I should know about between perf_counter keys?

--
Claytronic

[claytronic]

ok winning with most but the following are still not behaving ..

perf_counter["\SQLServer:_Databases(WEBCOLTECH\Data File(s) Size (KB)"]
perf_counter["\SQLServer:_Databases(WEBCOLTECH)\Log File(s) Size (KB)"]
where WEBCOLTECH is the database name (what if i wanted the total foot print of all the databases ?)

still getting not supported what have i missed
Thanks for you time ..
G

Try executing this from the Windows command prompt:

typeperf -qx | find "WEBCOLTECH"

It should echo back all of the performance counters with your database's name. Then just do a good old cut'n paste from the command prompt window. Perhaps you've got a simple whitespace problem. This has happened twice to me while setting up my Zabbix perfmon.

--
Claytronic

[clubbing80s]

thanks for the input .. it also answered my question on getting info on terminal server ..

[swaterhouse]

I like your idea of moving all of the perfmon counters into the database. Having everything in a template would save a bunch of time and centralize the configuration. Is there any 1.4 / 1.6 Win32 Agent differences I should know about between perf_counter keys?

--
Claytronic

Not that I have found - but you need the 1.4.2 version or later because the perf counters were pretty broken in 1.4.0 and 1.4.1.

I will upload my template later today. I dont have many triggers defined. I am struggling to figure out where I should set the thresholds. Right now my server has more than enough power so I am really just using the items for trending data.

[Jarno]

Hey guys! First of all i'm new to this forum and zabbix, this is my first post . I'm testing with zabbix for a few weeks now and it works great!

Currently i'm looking into perf counters. I was wondering where you uploaded this template swaterhouse. I've checked the wiki xml contrib page but didn't find anything. My plan is to make loads of these default templates for various services, and yes, i'm willing to share them

--

Jarno