server

HOW TO: Find When SQL Server Wait Stats Were Last Cleared

HOW TO: Find When SQL Server Wait Stats Were Last Cleared

For years I have found myself often needing these three pieces of information with regards to SQL Server: When was the last time the server was restarted? When was the last time the SQL instance was restarted? When was the last time the SQL Server wait stats were cleared? If the server itself is restarted, then the answer(…)

Top 3 Performance Killers For Linked Server Queries

Top 3 Performance Killers For Linked Server Queries

One thing I have noticed in all my years as a data professional: few users understand (or care) how far away they are from their data. Quite often they expect instant results from their queries despite there currently being an upper bound due to things like network bandwidth, the speed of light, and the data(…)

SQL Server Query Performance Tuning: A 12 Step Program

SQL Server Query Performance Tuning: A 12 Step Program

Performance tuning is hard. Everyone knows that. Has anyone ever tried to figure out why? Sure, there’s that big old “it depends” that gets tossed about. Look, at the end of the day you only have so many possible resource bottlenecks: disk, memory, CPU, and network. I don’t care if you are running Linux, Unix,(…)

Administering SQL Server 2012 Running On Windows Server Core

Administering SQL Server 2012 Running On Windows Server Core

Are you afraid of deploying (or supporting) an instance of Windows Server Core? Are you telling others to “stay away” because of your own fears of doing something new? Then I am here to tell you that you’re doing it wrong. Last month I decided that it was time to get down and dirty with(…)

Load More