Maintaining a database is an important job of the DBA role. One of the many maintenance tasks is ensuring that the disk does not fill up and your files are able to grow over time.
Tag: Monitoring
Query tuning 101: Non-trusted Foreign Keys
Foreign keys are an interesting feature of relational databases. They help enforce data integrity, sometimes help improve performance by eliminating joins, and sometimes slow down DML operations (inserts, updates, and deletes).
What keeps clearing my query stats?
I was building out a blog post about cardinality today and noticed that sys.dm_exec_query_stats was getting cleared my my Surface Pro 3 dev instance about every 30 to 60 seconds.
I opened object explorer to check if any jobs were running in SQL Agent that may be running DBCC FREEPROCCACHE
Understanding the new MAXDOP settings in SQL 2016
If you have just begun using SQL Server 2016 or you have been using it for a while now you may not have noticed the new MAXDOP settings.
I’m speaking at SQL Saturday 563 in Dallas
This will be my second time speaking at SQL Saturday in Dallas. My first was last year and it was a great time. I enjoyed hanging out with all the attendees and speakers. Who wouldn’t want to have a chat with Kalen Delaney or Bob Ward? The Dallas edition of SQL Saturday is on 9/24 in Arlington at the University of Texas. Be sure to set the date I’m sure this will be a lot of fun and there will be plenty to learn!
My session is A DBA’s guide to whole stack performance troubleshooting. You’ll want to check this out.
You can register for this free event here: http://www.sqlsaturday.com/563/eventhome.aspx
Also, be sure to follow me on Twitter (@SQLSME) and on LinkedIn!
I’m speaking at SQL Saturday 553 in Oklahoma City
This will be my first time speaking in Oklahoma on 8/27 in Oklahoma City. I’ve been to several customers there but have yet to meet people from the users groups.
My session is Analyze your query plan like a Microsoft Engineer! (SQL 2016 Edition). If you deal with tuning, monitoring, or developing queries for SQL Server, you’ll want to check this out.
You can register for this free event here: http://www.sqlsaturday.com/553/eventhome.aspx
Using PowerShell to find Processor issues & more
One of the top three performance killers for SQL Server is lack of processing power. I’d say that it’s second only to storage latency and more of a concern than memory. Although with anything in SQL we can say it depends.
Retrieving diagnostic data from SQL Server’s Default Trace
Have you ever tried to query the contents of the default trace and then spent more time trying to figure out the name of the oldest file than the actually analyzing the data?
Azure SQL Database waits you should be aware of…
I’ve been using Microsoft’s cloud database for some time now. I’ve had a few customers with various performance problems and thought I’d take a moment to highlight the interesting behavior you may run into as well.
New SQL Server community tool
For those of us in the US, it’s our day of independence. A day that stands for FREEDOM and happiness. Fireworks will light up the sky tonight! For the rest of the world it’s another random day in July. But don’t worry everyone can celebrate “Free”dom with this new community tool.
I’ve spent the last couple years writing, improving, and using this tool at my customers. This health check now has more than 300 data points and even pulls out bad practice and concerns from your procs. As of today, I gift it to the community. #SQLFAMILY
SQL TECH BLOG 