This is my first T-SQL Tuesday post. Thanks to Rick Krueger (blog) for hosting. On hearing this month’s subject I googled around a bit for the ‘official’ definition of a Rube Goldberg Machine. Wikipedia has it as “…a deliberately over-engineered or overdone machine that performs a very simple task in a very complex fashion, usually […]
A High-Availability with Automatic-Failover SQL Database Mirroring Configuration consists of a Principal Instance and Database, a Mirror Instance and Database, and a Witness Instance. Each instance must have a Database Mirror Endpoint – a special TCPIP endpoint with defined listener IP and port. A mirroring session is configured between these servers utilizing the dedicated mirror […]
I am a MS SQL Server DBA. My day to day work focuses on general databases administration (as much as it is possible to ‘focus’ on such a broad arena). Beyond strict database administration, I am interested in and involved with other MS SQL Server related technologies. I have a wider interest in other database platforms as well which […]
I wanted to check out the ideas presented by the SQLCAT team here to tune backup processes: Tuning the Performance of Backup Compression in SQL Server 2008 To follow along with the suggested trials, I took a series of backups of a ~50GB database on a test instance and captured duration, backup thru-put and CPU […]
In my environment we see an occasional situation where a system process blocks user process. To find what the system process was doing we looked to the wait_resource column in sys.dm_exec_requests to see what pages the user session was waiting on. We then took the pages numbers and looked to DBCC PAGE to determine […]
2014 Northwest Ohio SQL PASS User Group Top 10 Issues Identified By SQL Health Checks http://nwo.sqlpass.org/Home.aspx?EventID=2701 Detroit SQL PASS User Group Top 10 Issues Identified By SQL Health Checks http://nwo.sqlpass.org/Home.aspx?EventID=2701 IT/Dev Connections, Las Vegas, Nevada Extended Events Andy McDermid and Michael Otey Present Top Issues Identified by Health Checks http://www.webwire.com/ViewPressRel.asp?aId=189500 2015 […]
Here’s a brain-storm wish list of my dream sql health check (Did I really just say that? Dream sql health check? I did, didn’t I. That’s it, I’m knocking off early for a pint). —————————————————————– Useful for a DBA – minimum of unnecessary information, focus on actionable items, pinpoints issues to improve health Deliverable to […]
Quiz When I say Extended Events, what immediately comes to mind? A) “Save save save at Hank Honda’s Happy Honda Days Sales Event! Now Extended through Monday!” B) ”Although our cannoodler valves are of extremely high quality, with tight tolerances designed to last through several years of use, they may require maintenance in the […]
…besides work. Photo page and some words too. Coming soon.
About this time last year I was on a river trip. Some friends had lucked into a permit for the Main Fork of the Salmon in Idaho. The Main Fork of the Salmon is a designated Wild and Scenic River and, for anybody who loves wilderness, rivers and white water, the Salmon is surely on […]