In a previous post, Collecting Historical Wait Statistics, I discussed how you can easily collect historical wait stats by using the DMV sys.dm_os_wait_stats. Well today, I’d like to cover the same concept, but this time collect historical IO file stats from the DMV, sys.dm_io_virtual_files_stats. However, I wanted to improve on the code to make it even easier to implement. The data collection process is still implemented the same way. First, we’ll need to create a history table to store the data. The data is stored in time slices with the cumulative values as well as the difference (TimeDiff_ms, NumOfReadsDiff, NumOfWritesDiff,...
Continue reading...2013
Collecting Historical Wait Statistics
As a DBA, I’m sure you’ve heard many times to always check the sys.dm_os_wait_stats DMV to help diagnose performance issues on your server. The DMV returns information about specific resources SQL Server had to wait for while processing queries. The counters in the DMV are cumulative since the last time SQL Server was started and the counters can only be reset by a service restart or by using a DBCC command. Since DMVs don’t persist their data beyond a service restart, we need to come up with a way to collect this data and be able to run trending reports...
Continue reading...In-Memory OLTP and the Identity Column
Over the past month I’ve been playing around with the new In-Memory OLTP (code name: “Hekaton”) features within SQL Server 2014 CTP2. My organization is all about low latency applications, and this is one feature of SQL Server that I need to get familiar with ASAP. To do this, I started my own little project that takes an existing database and converts parts of it into in-memory tables. Once that step is complete, I could work on rewriting the TSQL code. It might seem fairly simple, but with every new feature of SQL Server there are usually limitations. And one...
Continue reading...TSQL Tuesday #47 – Your Best SQL Server SWAG
The host for T-SQL Tuesday #47 is Kendal Van Dyke (blog|twitter), and his topic of choice is about the best SQL Server SWAG we ever received at a conference; specifically, the “good stuff”. I’ve been doing a lot of work with SQL Server over the years, but I’ve only had the opportunity to attend the big conferences a few times. As a matter of fact, next week will be my first time attending the SQL PASS Summit. We’re supposed to talk about the “good stuff” and not any of the “cheap tchotchkes” that are given away by the vendors, but...
Continue reading...One Year Later
Wow! It’s been one year since I launched my blog, and my how things have changed. Accomplishments Over the Past Year I’ve had a chance to interact with a lot of people relating to many of the posts on my blog, and even run into a few people that said “Hey I know you through your blog”. I’ve gotten much more involved in the #sqlfamily through Twitter, Stackexchange, as well as through my local SQL Server user group. Although I’ve attended meetings at my local group off and on over the past several years, I am now making a specific...
Continue reading...
