Today I begin a week-long series where I will be discussing various SQL Server Monitoring Tools. My primary job is to help people with my consulting workshop Comprehensive Database Performance Health Check. While I help the customer with their various SQL Server performance issues, I often see my customers struggle with the monitoring their SQL Server’s health. One of the primary discussion at the end of consultation which we do is what tool is the best for their environment and how it can prevent them to walk into another trouble. Today we will talk about SQL Diagnostic Manager (SQLDM) in brief.
SQL SERVER – Monitoring and Troubleshooting SQL Server Got Easy with Diagnostics Tool
Blogging has never been an easy task. With close to 9 years of non-stop learning and sharing has got me into a rhythm that I rarely miss a single day without writing one. Over these years, there is one topic area that gets most number of hits based on subject.…
Read MoreSQL SERVER – Backups are Non-negotiable Lifeline for DBAs
I have had my share of DBA friends who have told me a number of horror stories from their experiences. Thinking back, these look like moments to laugh away but there are some serious learnings we get from these experiences. I am a personal believer of learning something in everything…
Read More
SQL SERVER – Monitoring SQL Server Never Got This Easy
In administering SQL Server databases, the DBA is often presented with the task of identifying resource bottlenecks on the system and the sources of those bottlenecks. Also, the DBA is challenged with the task of identifying why specific queries take significant time to execute or affect the performance of other queries on the system. This allows the DBA to find opportunities to tune queries and improve their performance and the overall performance impact on the system. In this blog we will explore identifying if any disk I/O bottlenecks are present that impact query performance on the system. Such action would allow a DBA to further deal with the I/O bottleneck. Let us learn about Monitoring SQL Server.
SQL SERVER – Exploring SQL Auditing with SQL Compliance Manager
As database administrators, we are constantly quizzed by our superiors to answer questions such as: how secure is our network, how secure is our data, is data secure at rest, is data secure in transition, who is accessing my data? All these are basic yet compelling queries businesses ask. In this age of competitive businesses, organizations are becoming tech savvy in building a secure fort for their critical data. Having worked on many projects in the past, these security measures are something I know are non-negotiable from an implementation point of view for administrators. When on this topic, I am reminded of a conversation about SQL Compliance Manager, I had with a junior DBA named Siva.
SQL SERVER – Idera SQL XEvent Profiler – a Free Tool for XEvent Monitoring
Download Extended Event Profile FREE We often resist the change, we do not like change and we keep on using the same old technology which we have been using it to resolve the new challenges which we face in our daily life. The Extended Event is such a technology as…
Read More
SQL SERVER – Retrieve and Explore Database Backup without Restoring Database – Idera virtual database
I recently downloaded Idera’s SQL virtual database, and tested it. There are a few things about this tool which caught my attention. Let us learn about Retrieve and Explore Database Backup without Restoring Database.