SQL Server Monitoring & Routine Health Checks
Discover Common Issues and a Plan for Resolution
Monitoring is one of the most essential parts of SQL Server administration. SQL Server is a business critical component for most companies’ line-of-business applications and regular monitoring is essential to maintain optimal operation as well as troubleshoot performance issues. In this presentation, you’ll learn about some of the essential SQL Server metrics that you need to track to maintain your SQL Server instance. First, you’ll learn about some of the essential tools you can use to monitor your SQL Server instances.
Some of the important SQL Server facets to monitor include:
- Capacity planning
- Performance monitoring including performance baselines
Finally, we will discuss the importance of integrating health checks into your monitoring plan, and review the top issues uncovered during routine health checks and a prioritized three-step plan on how to resolve those issues.
Below is a preview of the webinar transcript.
The first part of this presentation, some of the things that I’m going to cover are the SQL Server monitoring tools. These are mostly tools that come with the SQL Server itself or the Windows Server operating system. There’s also one extra tool that is the download that I’ll talk about. These are some of the tools if you’re doing this kind of monitoring on your own.
Then, we’re going to look at some of the points that you need to monitor to keep track of your SQL Server and keep it in good operating health. First, we’re going to look at capacity planning. It’s important to make sure that you have growth planned for for your system and you don’t run out of either storage, memory or CPU capacity. Next, we’re going to look at some of the important security points to manage. SQL Server is a very secure database platform but that doesn’t mean you just have to let it go. There are a number of things you need to look for there. Then, backups are another thing. You might not think of backups as an operational kind of monitoring point but if you can’t restore your system, then you know you’ve got a problem. Keeping on track of your backups is an essential part of your monitoring plan.
Fill out the form to the right to watch the webinar in its entirety. >>
Watch The Webinar Here