The tag has no usage guidance.

learn more… | top users | synonyms

1
vote
2answers
963 views

Understanding Disk Partition Alignment for Windows Server 2012 and SQL Server 2014

I am about to setup a SQL Server 2014 on a Windows Server 2012. Starting from best performance on the drive I formatted the drive with 64k allocation unit size. Now I am stuck using Diskpart to set ...
0
votes
0answers
24 views

Howto defrag a Galera Cluster (5.5.41) with innodb_file_per_table = off? After TRUNCATE a huge table is defrag needed?

First question how to defragment our cluster (see Galera and MariaDB config)? I don't know how Galera replicates the new data files size? Second question, is defrag needed? We truncated a 30 GB table ...
0
votes
0answers
204 views

Is my SQL Job causing the High Disk usage?

I have a concern regarding High Average disk queue length for one of my server with below configuration: Version: SQL 2005 with SP3, standard edition. windows: version 2003 r2 SP2 No Processors= 4 ...