How to set up Zabbix to monitor SQL Server Failover Active …
Dec 3, 2012 · We have a Zabbix 2.0.3 server instance set up monitoring a bunch of different servers, but now we need to set it up to monitor and notify any alerts in regards to the SQL …
Where are SQL Server connection attempts logged?
Jul 20, 2011 · 33 Another way to check on connection attempts is to look at the server's event log. On my Windows 2008 R2 Enterprise machine I opened the server manager (right-click on …
windows internal database consuming a lot of memory - sql server
I have a trial windows 2008 r2 with sqlexpress 2008 installed on it but he also has his one native sql server for sbs monitoring and a instance called Windows Internal Database which is …
SQL 2008 R2 says access denied when logging in remotely
Aug 29, 2014 · I have an SQL 2008 R2 server and a monitoring server both on the same physical network (but different VLANs). The monitoring server is always connecting to the SQL server …
sql server 2008 - Using Zabbix how to monitor database without ...
Nov 28, 2021 · -1 I want to monitor the data on Microsoft sql server database using Zabbix. for example, in table T1 containing columns col1, col2, col3, when the value of col1 is less than 0 …
Weird memory usage in Windows Server 2008 R2
How exactly did you " Having now limited SQL Server RAM usage (min/max) to 13GB, this shouldn't happen again."? I'm running a Win 2008 R2 machine with SQL 2008 R2 and I'm …
Activity monitor is unable to execute queries against server
If SQL is running on a Windows 2008 R2 server or cluster, go to the Performance Monitor application, expand the Data Collection Sets, then select the System Performance, if the arrow …
Listing all Data Sources and their Dependencies (reports, items, etc ...
Apr 23, 2015 · I am new to SQL Server, and I am sorry if there is an obvious solution to my question but I can't seem to find it. I am looking to generate a report (or list) of all the data …
Can i monitor performance of particular table in sql server 2008 ...
Jul 16, 2010 · I want to monitor all the DML commands that run on a particular table of my database in sql server profiler. Im using sql server 2008 R2
Index usage, monitoring and dropping unused indexes - SQL …
Feb 26, 2014 · I have a procedure that gathers index usage across a range of instances and databases, mainly using sys.dm_db_index_usage_stats. I am then going through indexes …