Posts Tagged ‘SQL Server’
How can I use ephemeral drives with SQL Server tempdb?
First of all, if you are not familiar with ephemeral storage, then check out our previous post on the topic. SQL Server loves to use tempdb and believe it or not it’s not relegated solely to the types of queries you might think, such as ordering and grouping. It’s used by a whole world of…
Read MoreCreating an Extended Events Session
Creating an extended events session is pretty straight forward with SQL Server 2012 as Microsoft has finally introduced a graphical user interface. During my time as a DBA, I often needed to create a quick trace to capture query activity for a particular table. So, let’s run through how we might do this with extended…
Read MoreTracing Events in SQL Server
When you want to trace or instrument SQL Server activity, whether it be for performance purposes, security, auditing, etc. – you really have two baked in methods. Well, there are a few others – but they are not all that robust. Tracing with SQL Profiler Tracing with SQL Server profile is the good ol’ way…
Read MoreSQL Server Data Compression
When people talk about data compression they are typically discussing archival – but Microsoft has used this very popular technology in a way that has managed to fall into the category of performance improvement. Here I am going to give you an example of how we can use compression to decrease disk latency, maximize memory…
Read More