All Questions
6 questions
2
votes
1
answer
4k
views
Should TempDB SSD Drive be formatted with 64 Kb Allocation Unit Size?
We have installed dedicated SSD drives for TempDB
First question - should these drives be formatted with 64 Kb allocation size ? Currently it shows 4 Kb (Bytes per Cluster = 4096)
Does TempDB ...
- 5,964
1
vote
0
answers
839
views
SQL TempDB PCI-E NVMe card - 4K or 64K
Our primary OLTP workload is tempdb heavy (both reads & writes) based on virtual_file_stats DMV, and based on SPs all of which heavily use #tmp tables.
The server has 400GB of memory, more than ...
- 1,174
3
votes
3
answers
690
views
Configuring physical storage for a Microsoft SQL Server installation
I'm configuring a Microsoft SQL Server installation which will use a SAN for storage. For SAN storage I have:
A small number of SSD disks
A larger number of 10K disks
My SAN supports storage ...
- 191
2
votes
2
answers
1k
views
Where to place tempdb and logfiles
I have fallowing configuration for my SQL 2014 server:
SSD RAID 1 - for data files
SSD RAID 1 - for tempdb? logfiles?
HDD (SAS 15K) RAID 1 - for tempdb? logfiles?
I noticed that sql uses tempdb ...
- 23
5
votes
1
answer
2k
views
SQL Server 2012 Local SSD TempDB Slow
I have a production deployment using local SSDs for tempDB. I have 2 SSDs in a RAID1 configuration. I am seeing average reads of 1-2ms but the average writes are showing as 1377ms on all four of my ...
- 5,785
6
votes
2
answers
1k
views
Major Discrepancy Between SQLIO IOPS/Throughput Stats and DBCC CHECKDB Operations
I'm conducting time trials on a new SSD array running both SQLIO tests and a real-world workload of DB restores and DBCC CHECKDB calls. I'm seeing a major discrepancy between the IOPS and throughput ...
- 1,935