vitamindba

SQL Server Always On Read Only Routing Lists

• by Justin Figg

• vitamindba

With the release of SQL Server Always on came the ability to query replica’s and offload read only requests. This...

2019-02-12 (first published: 2019-01-23)

1,885 reads

Let’s talk SQL Server Waits: Topic 2 – CXPacket

• by Justin Figg

• vitamindba

With our effort to talk about SQL Waits we come across another common wait called CXPacket. Last week we reviewed...

2019-01-30 (first published: 2019-01-16)

2,665 reads

SQL Server Transaction Log is full due to XTP Checkpoint Error 9002, Severity 17, State 16

• by Justin Figg

• vitamindba

I want to take some time and discuss my experiences with a certain SQL Server error, error 9002. Error 9002...

2019-01-10

2,627 reads

Let’s talk SQL Server Waits: Topic 1 – SOS_SCHEDULER_YIELD

• by Justin Figg

• vitamindba

Over the next few weeks we will be reviewing some of the common SQL Server Waits. We will explain what...

2019-01-03

1,104 reads

What is the Max Degree of Parallelism setting for SQL Server?

• by Justin Figg

• vitamindba

Max Degree of Parallelism is a setting that is often changed to improve performance in SQL Server.  What exactly does...

2019-01-07 (first published: 2018-12-21)

2,559 reads

Seeing WriteLog wait type on your SQL Server?

• by Justin Figg

• vitamindba

One of the more common wait types for SQL Server is called WriteLog.  In its most basic form it is...

2018-12-27 (first published: 2018-12-18)

2,430 reads

Get Rid of those unused indexes!

• by Justin Figg

• vitamindba

Indexes in relational databases are very helpful and increase the speed to access data.  However maintaining indexes is just as...

2018-12-11

181 reads

Enabling Query Store

• by Justin Figg

• vitamindba

Performance tuning in SQL Server is one of the main jobs a DBA has.  Starting with SQL Sever 2016 a...

2018-12-05

823 reads

Deadlocks in a SQL Server Database

• by Justin Figg

• vitamindba

Deadlocks in SQL Server happen when 2 (maybe more) processes are fighting over a resource in the database and are...

2018-12-18 (first published: 2018-12-03)

3,108 reads

Database Stuck in Suspect Mode

• by Justin Figg

• vitamindba

My holiday week did not started off very good.  I come in and find a UAT environment database in suspect...

2018-11-27

536 reads