How to monitor MS SQL server

Troubleshooting
1

how to monitor ms sql server with checkmk and and what server role user needs to be able to monitor sql server

2

Have a look at the catalog of check plugins: Check Plug-Ins Catalog

The checks need the Checkmk mssql.vbs plugin installed in the agent.

Usually the SYSTEM account the checkmk agent is running under has sufficient rights to connect to the SQL server.

More details can be found in the header of the plugin: checkmk/mssql.vbs at master · tribe29/checkmk · GitHub

3

there is no clear instruction or tutorial how to monitor ms sql server with checkmk its allways like check this check that out.

4

i just wana buy this product to make my job easy i dont wana speend hours days try to find how it works

5

Hey, relax and slow down a bit. you have received a perfectly valid and helpful response. for free. In about an hour’s time after asking. It’s a community forum here, not a commercial support channel!

3 Likes
6

Hi @Ntahir

take a look here: Monitoring MySQL

This blog article might be helpful as well: Monitoring of different server types: SQL servers | Checkmk

Cheers
Elias

1 Like
7

where can i download mssql.vbs and is this the only file i need to monitor ms sql server

8

@Ntahir

If you read the resources that the community has provided here, you will find everything.

The path is here: Monitoring MySQL

PS> copy "c:\Program Files (x86)\checkmk\service\plugins\mk_mysql.vbs" c:\ProgramData\checkmk\agent\plugins\
9

ok thanks i found it and copied it. what is the next step?

10

@Ntahir , as @martin.schwarz already wrote: This is a user community, which offers help from one user to the other.

This is NOT a commercial support channel.

Read the manual, it gives you all instructions you need to know.

11

image
image1012Ă—468 30.4 KB

and what role and permision the user should have for the user credintials?

12

The answer is in the previously linked article as well, right at the very top: Monitoring MySQL

so please, I beg you: RTFM :wink:

13

ok i get ony the user who are paying will get the help and answer all others must read the articles

14

Do not confuse MySQL with MS SQL…

15

You are the first one that may enter my block list in this forum.

2 Likes
17

Sorry, you are right.

18

yah do can you please send me the article link for ms sql server

19

Hi @Ntahir,

I request you to please be considerate of the people who responded to you in this thread, especially as they have shown how genuinely they want to help you. I have hidden one of your posts which clearly is in the “Dont’s” stated here. (unhelpful criticism, aggressively demanding for answers).

This is a community forum powered mostly by enthusiastic Checkmk users who want to help people like you. It’s unfair to give them this kind of treatment.

If we see this again, the admins will have to silence your account.

Regards,
Faye

7 Likes
20

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed. Contact an admin if you think this should be re-opened.