|
|
Browse by Tags
All Tags » security » monitoring (RSS)
-
First part of question is a pure newbie FAQ to know about, and the simple answer would be it is one of the Clustering type you can adopt within your SQL Server environment.
To cover on newbie aspect both Active/Passive & Active/Active configuration is available within SQL Server, both operating system & SQL engine work together to ...
-
As you are aware DMV - Dynamic management views are very good to provide server-level information and some of them with detailed information on the execution environment of the database engine.
Just to introduce about DMVs, there are two types of dynamic management views and functions:
Server-scoped dynamic management views and functions. ...
-
How do you define the terms ''Performance Monitoring''? What is your baseline & benchmarks? Have you ever used PERFMON (SYSMON) & PROFILER for serious performance issues within your SQL Server environment?
The answer may be not 'yes' for all the questions above, in general getting know more about performance monitoring methods is not ...
-
Recently got stuck with the stored procedure sys.sp_dbmmonitorupdate which is used to monitor the database mirroring session. As usual you could do using the GUI tool, but sometimes using TSQL methods is good enough to see what is happening on your system.
On the system with SQL 2005 Service pack2 when executing this ...
-
Can we audit the activity inside the SQL Server 2008 to capture SELECTs activity?
For the first time I though CDC will be useful to DBAs in auditing the activity on the database, but its not entirely. It is equivalent to auditing functionalities and in short CDC is more poised towards the ETL for incrementatl data load and that uses an ...
-
As you have seen the worst offending issues in this case, better to keep up with alerts using any tools to alert the support team during out of hours time. During the day time I believe you will have to review the logs by referring to SQL error log & event viewer.
Monitoring and protecting the SQL Server from attack say even hacking or ...
-
Well its a self-promotion of my write-up on SQLCentric tool which helps the DBAs out there to monitor the SQL farm effectively, more on here what I've been saying on this tool.
|
|
|