Many companies rely on the job scheduling and alerting services provided with the native SQL Server Agent service. From backups to SSRS subscription to SSIS packages, SQL Server Agent has the capability to run many types of business critical tasks on a regular schedule or can be programmatically triggered to start from other processes as […]
Category Archives: SQL Server Performance
28
Mar
Mar
The main language used to communicate with different databases is the Structured Query Language (SQL). A slow SQL application can cost your company more than money and time, but cause customer dissatisfaction and lower sales as well. There are a myriad of reasons why your SQL application runs slow. Everything from initial coding processes to […]
SQL Server has a bounty of self-diagnostic data that any good DBA can monitor and analyze. This analysis is often triggered by an unexpected event like queries that begin to run longer than usual or a spike in CPU utilization. Finding the root cause of such events is not always easy but through a simple […]
It’s that time of year that a good amount of IT departments are dedicating time to researching and planning for their 2018 IT budgets. As you know, the growth of your company and it’s data depends heavily on your IT infrastructure, so the decisions you make and the costs of those choices are very critical. […]
Technical communities are thriving and the knowledge they provide to professionals is immense. In the SQL Server community especially, countless blog sites, forum posts, tweets, webinars and white papers exist that help DBAs solve tough problems every day and we are all fortunate to have such information available to us with a simple Web search. Sometimes, […]
You know the old joke that goes, “A DBA walks into a bar, sees some friends at a couple of tables and asks if he can join them.”? Well, as DBAs we are used to dealing with tables. Whether the data comes from a log file, trace file, or XML, we want to turn it […]
Microsoft announced the much anticipated SQL Server 2017 release is available for download today. This version is packed with so many features, here are just a few of what we’re looking forward to here at SQLWatchmen: Always On Availibility Group – supporting the ability to cross database transactions among all databases, as well as, clusterless […]
Intro Microsoft SQL Server has had Mirroring starting with version 2005, and now that SQL Server 2012 is released, there is an additional feature set called AlwaysOn (marketing info | technical info). AlwaysOn in currently an Enterprise only feature, so Standard Edition users will still need to use Mirroring. I would describe AlwaysOn this way: […]