I/O Baseline Comparison – Idera Diagnostic Manager

• by SteveHood79

• Simple SQL Server

What servers need the most attention when it comes to I/O?  When I increase the memory on a server what...

2016-02-29

915 reads

I/O Baseline Comparison – Idera Diagnostic Manager

• by SteveHood79

• Simple SQL Server

What servers need the most attention when it comes to I/O?  When I increase the memory on a server what effect does it have on I/O?  What was it...

2016-02-29

1 reads

Wait Stats Baseline Comparison – Idera Diagnostic Manager

• by SteveHood79

• Simple SQL Server

Database servers have to wait on different resources, and these waits are huge to the performance of SQL Server.  Sometimes...

2016-02-22

666 reads

Wait Stats Baseline Comparison – Idera Diagnostic Manager

• by SteveHood79

• Simple SQL Server

Database servers have to wait on different resources, and these waits are huge to the performance of SQL Server.  Sometimes something changes without our knowledge and is running differently...

2016-02-22

Shrinking Database Log Files

• by SteveHood79

• Simple SQL Server

Files in SQL Server need to grow as the database grows, and in very specific circumstances need to be shrunk...

2016-02-15

1,267 reads

Shrinking Database Log Files

• by SteveHood79

• Simple SQL Server

When should you shrink your log files and what does it mean to performance?

2016-02-15

7 reads

Database Log VLFs

• by SteveHood79

• Simple SQL Server

Virtual Log Files (VLFs) split a physical database log file into smaller segments, which are required for how log files...

2016-02-08

776 reads

Database Log VLFs

• by SteveHood79

• Simple SQL Server

Transaction logs are split into VLFs which affects performance. How large are yours and what does that mean for you?

2016-02-08

3 reads

TempDB Excessive Memory Usage Example

• by SteveHood79

• Simple SQL Server

I see TempDB using more memory than I feel it should and found a way to resolve it.  Previously I...

2016-02-05 (first published: 2016-02-01)

2,715 reads

TempDB Excessive Memory Usage Example

• by SteveHood79

• Simple SQL Server

I see TempDB using more memory than I feel it should and found a way to resolve it.  Previously I dove into technical details and questioning what I saw...

2016-02-01

11 reads