-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Database Superhero’s Blog

Tracy is the Database Superhero for ChannelAdvisor. She has spent over 20 years in IT and has used SQL Server since 1999. Tracy covers all aspects of administration and deals heavily with performance tuning and high availability and disaster recovery. Tracy is a co-organizer of a Special Interest Group (SIG) dedicated to advanced DBA topics in our local user group TriPass. She is also the founder of http://WeSpeakLinux.com. Before she worked full-time as a DBA she was formally a developer and network administrator. She also tinkered with databases in middle/high school to keep her sports card collection organized.

Database Superhero Adventures, July 2018

Sorry readers, I was having some many adventures there was no June edition.  In May, I had SQLSaturday Dallas where I got to drive a pickup truck because what else would you drive in Texas.  I presented my newest and most popular related series of blog posts Collecting Performance Metrics Read more

0 comments, 347 reads

Posted in Database Superhero’s Blog on 2 July 2018

Database Superhero Adventures, July 2018

Sorry readers, I was having some many adventures there was no June edition.  In May, I had SQLSaturday Dallas where I got to drive a pickup truck because what else would you drive in Texas.  I presented my newest and most popular related series of blog posts Collecting Performance Metrics Read more

0 comments, 9 reads

Posted in Database Superhero’s Blog on 2 July 2018

Query Store Error State

We recently discovered some of our databases in an Error State for SQL Server.  Microsoft has indicated this is a race condition when failover/restart happens on QDS cleanup.  They are working on a bug fix for it.  For now, it suggested you set up something that checks your databases to… Read more

6 comments, 35 reads

Posted in Database Superhero’s Blog on 26 June 2018

Query Store Error State

We recently discovered some of our databases in an Error State for SQL Server.  Microsoft has indicated this is a race condition when failover/restart happens on QDS cleanup.  They are working on a bug fix for it.  For now, it suggested you set up something that checks your databases to… Read more

6 comments, 208 reads

Posted in Database Superhero’s Blog on 26 June 2018

Query Store Usage and Adaptive Plan Tuning Usage

Recently, there are have been a few articles about the lack of adoption of Query Store. Note the following:

  1. Brent Ozar blogged about it in this article Building SQL ConstantCare®: Why People Aren’t Using Query Store.
  2. Erin Stellato blogged about it in this article Why Aren’t You Using Query…

Read more

0 comments, 2,143 reads

Posted in Database Superhero’s Blog on 17 June 2018

Query Store Usage and Adaptive Plan Tuning Usage

Recently, there are have been a few articles about the lack of adoption of Query Store. Note the following:

  1. Brent Ozar blogged about it in this article Building SQL ConstantCare®: Why People Aren’t Using Query Store.
  2. Erin Stellato blogged about it in this article Why Aren’t You Using Query…

Read more

0 comments, 8 reads

Posted in Database Superhero’s Blog on 17 June 2018

Spreading Job Run Times Out on an MSX/TSX Scheduled Job

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… Read more

2 comments, 34 reads

Posted in Database Superhero’s Blog on 29 May 2018

Spreading Job Run Times Out on an MSX/TSX Scheduled Job

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… Read more

2 comments, 1,456 reads

Posted in Database Superhero’s Blog on 29 May 2018

T-SQL Tuesday #102 – Giving Back

This month Rily Major (b | t) ask us to talk about how we are giving back to the community if we are or how we would if we aren’t, to lay out a plan.  I’m already heavily involved in the community and haphazardly landed that way with… Read more

2 comments, 12 reads

Posted in Database Superhero’s Blog on 8 May 2018

T-SQL Tuesday #102 – Giving Back

This month Rily Major (b | t) ask us to talk about how we are giving back to the community if we are or how we would if we aren’t, to lay out a plan.  I’m already heavily involved in the community and haphazardly landed that way with… Read more

2 comments, 195 reads

Posted in Database Superhero’s Blog on 8 May 2018

Database Superhero Adventures, May 2018 Edition

Well, three SQL Saturdays down for April.  Raleigh which was local for me and I helped organize, Philadelphia where I got to give two talks, and Wheeling which made the news. At least this month we had spring weather for all of them.  On the way to Philadelphia, the crew… Read more

0 comments, 169 reads

Posted in Database Superhero’s Blog on 1 May 2018

Database Superhero Adventures, May 2018 Edition

Well, three SQL Saturdays down for April.  Raleigh which was local for me and I helped organize, Philadelphia where I got to give two talks, and Wheeling which made the news. At least this month we had spring weather for all of them.  On the way to Philadelphia, the crew… Read more

0 comments, 10 reads

Posted in Database Superhero’s Blog on 1 May 2018

Guide for Setting up Telegraf to Monitor InfluxDB

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… Read more

0 comments, 35 reads

Posted in Database Superhero’s Blog on 30 April 2018

Guide for Setting up Telegraf to Monitor InfluxDB

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… Read more

0 comments, 254 reads

Posted in Database Superhero’s Blog on 30 April 2018

Guide for Set Up of Telegraf for Monitoring Windows

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… Read more

0 comments, 556 reads

Posted in Database Superhero’s Blog on 17 April 2018

Guide for Set Up of Telegraf for Monitoring Windows

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… Read more

0 comments, 16 reads

Posted in Database Superhero’s Blog on 17 April 2018

T-SQL Tuesday #101: My Essential SQL Server Tools

This T-SQL Tuesday is brought to us by Jens Vestergaard (b |  t), and we are asked to share our favorite SQL Server tools. Hint Profiler will not be on the list. But where do you start there are so many tools out there. In alphabetical order here… Read more

0 comments, 14 reads

Posted in Database Superhero’s Blog on 10 April 2018

T-SQL Tuesday #101: My Essential SQL Server Tools

This T-SQL Tuesday is brought to us by Jens Vestergaard (b |  t), and we are asked to share our favorite SQL Server tools. Hint Profiler will not be on the list. But where do you start there are so many tools out there. In alphabetical order here… Read more

0 comments, 539 reads

Posted in Database Superhero’s Blog on 10 April 2018

Procedure to Create New Filegroups and Files

Problem

For good database design, it is not idea to have everything in your PRIMARY filegroup so you can do partial backups, piecemeal restores, and for performance to separate your tables and indexes. You need different filegroups when looking at separating your indexes and tables and partitioning. Creating all these… Read more

0 comments, 192 reads

Posted in Database Superhero’s Blog on 3 April 2018

Procedure to Create New Filegroups and Files

Problem

For good database design, it is not idea to have everything in your PRIMARY filegroup so you can do partial backups, piecemeal restores, and for performance to separate your tables and indexes. You need different filegroups when looking at separating your indexes and tables and partitioning. Creating all these… Read more

0 comments, 13 reads

Posted in Database Superhero’s Blog on 3 April 2018

Older posts