Simple SQL Server

Powershell, when were my servers rebooted?

• by SteveHood79

• Simple SQL Server

One of my servers wasn’t rebooted when it should have been and I never realized it until after the outage...

2016-06-01

495 reads

Powershell, when were my servers rebooted?

• by SteveHood79

• Simple SQL Server

One of my servers wasn’t rebooted when it should have been and I never realized it until after the outage was over.  The big deal wasn’t that it didn’t...

2016-06-01

File Growths

• by SteveHood79

• Simple SQL Server

I hinted at file growths in my previous posts about shrinking data and log files.  Then I talked about growing...

2016-04-11 (first published: 2016-03-29)

1,791 reads

File Growths

• by SteveHood79

• Simple SQL Server

I hinted at file growths in my previous posts about shrinking data and log files.  Then I talked about growing log files in my post Database Log VLFs.  However,...

2016-03-29

2 reads

Database Growth Trends – Idera Diagnostic Manager

• by SteveHood79

• Simple SQL Server

How fast are your databases growing?  Should I panic about a 1 TB database that has 100 GB free on...

2016-03-21

620 reads

Database Growth Trends – Idera Diagnostic Manager

• by SteveHood79

• Simple SQL Server

How fast are your databases growing?  Should I panic about a 1 TB database that has 100 GB free on disk?  Am I safe with a 100 GB database...

2016-03-21

2 reads

Multiserver Queries

• by SteveHood79

• Simple SQL Server

You can run queries against multiple servers at once, and it’s quite useful for a number of reasons.  I use...

2016-03-14

695 reads

Multiserver Queries

• by SteveHood79

• Simple SQL Server

Setting up registered servers and practical uses of multiserver queries in SSMS.

2016-03-14

3 reads

Recompile Monitoring using XEvents

• by SteveHood79

• Simple SQL Server

Recompiles can be a hidden bottleneck on your server, and it may not be too obvious.  I should know, it...

2016-03-17 (first published: 2016-03-07)

1,613 reads

Recompile Monitoring using XEvents

• by SteveHood79

• Simple SQL Server

How recompiles can hurt you, and how you can hunt them down using sql_statement_recompile.

2016-03-07