We often get a complaint from our client or application team that this particular query sometimes performs worst or at this specific time, the whole system performs very poorly. And, they want you to find the cause of performance issue. To start with basic performance troubleshooting, you need historical data which can tell you what […]
Verifying SQL Server Instance workload
Read more
As a DBA, you might be supporting different-different clients. Basically, you would be dealing with thousand of SQL Servers, and it is tough to remember which SQL Server is having what kind of workload – OLTP or DSS (aka DW). If your client reports to you performance issue on one of the SQL Servers instance, […]
The Secret of the Database Boot Page#9 – Part1
Read more
Recently, I presented on SQL Server database “Boot Page” at Singapore SQL Pass Chapter user group. It was a great knowledge sharing experience, and It motivated me to share the knowledge to a wider audience. So, I will be blogging all the part of the demos with all possible details so that you enjoy the […]