Problem Recently I had a situation where I was looking at a SQL Instance due to a contractor who controls the system wanting to drop some indexes and they couldn’t because they couldn’t get a lock request. Sadly, they were using the GUI to try to accomplish this. Always makes
SQL Server can run in any Virtual Machine that has the appropriate operating system (yes, I said that because I have some hope, that we will one day learn Linux and run on that OS but until that day, we are mostly running on the Windows Server). There are several
Happy St. Patrick’s Day (are you wearing something green)! For March I asked everyone to blog something related to Query Store, here is a summary of in alphabetical order of the blog posts we received although Rob Farley gets credit for being first. Tracy Boggiano (b | t) – I
This month’s T-SQL Tuesday blogging party is brought to you well by me and I wanted to talk more about Query Store. I did write a book on it but there if still more to know about that is not in the book. I am sure the rest of everyone’s
I often get emails asking the same time of questions about the setup of Telegraf for SQL Server and Windows while people are trying to set it up. Hopefully, this blog post will help answer most people’s questions and help them troubleshoot the setup. First, if you have a problem
I’ve worked for SaaS companies for the last 6 years or so. So our queries are largely the same across our system and by default Query Store is per database. So it would be handy to have a central repository to help you determine which queries across your whole server
Recently, there are have been a few articles about the lack of adoption of Query Store. Note the following: Brent Ozar blogged about it in this article Building SQL ConstantCare®: Why People Aren’t Using Query Store. Erin Stellato blogged about it in this article Why Aren’t You Using Query Store?
Problem My company heavily uses MSX/TSX jobs for everything. But our SAN doesn’t necessarily like if we run all our index maintenance, backups, and integrity checks at the same time. So here is a quick little post on how you can schedule the workload to spread out across all your servers across
Problem If you been reading this series you are used to looking at Windows and SQL Server but who knows what InfluxDB is and what to look at there especially if installed it on Linux. Lucky for us there is a dashboard to use to watch InfluxDB as well so
Problem As good DBAs, we sometimes have the need to monitor stats or just want to be nice to our system admins and share our new shiny toys and watch Windows using the same tools as SQL Server. Install and Configure Telegraf for on Windows The solution for this is fairly simple