SQL Server performance objects are found inside the Performance Monitor tool, also known as perfmon. If you are using Performance Monitor for gathering resource metrics for SQL Server then you are familiar with a screen such as this one: You can see I have navigated to the SQL Server Plan Cache counter, selected Cache Hit … Read more
The official documentation suggests that SQL Server Standard edition is not NUMA aware due to Standard having limits on the amount of hardware available.
I don’t want to alarm you, but your cloud is infested with vampires. These cloud vampires are costing you money. They are also difficult to find.
Deadlocks are the result of application code combined with a database schema that results in an access pattern that leads to a cyclical dependency.
There I was, talking about upgrading to SQL Server 2017 at SQL Konferenz last month. Despite the title of the talk, I was not expecting such a question. But there it was: “Is SQL Server 2017 stable enough to use?”
Last week while at the Microsoft MVP Summit, I had the honor to attend a session delivered by Pedro Lopes who shared a detailed a list of SQL Server Tiger team bookmarks.
