Question : Our databases files (data and log) of (a lot of) SQL Servers are hosted on flash storage (SAN), […]
Tag: san
Use Windows 2016 Storage Replica for SQL Server failover cluster instance
Question : We have two standalone servers with local storage. Based on our needs we have determined that we need […]
Sql Server & NetApp Sql Snap Manager
Question : Does anyone use netapp’s sql snapmanager? We are in the process of trying to decide if it is […]
Checking database files for physical fragmentation
Question : I searched the Internet and did not find clear explanation for when I should try defragmenting physical database […]
SAN IOPS figure
Question : Recently we’ve been having high disk latency issue and wanted to benchmark one of our mount points on […]
SQL Server – Separating data, log, and TempDB files on a SAN
Question : I have a SQL Server connected to a SAN. Our new storage vendor recommends that all LUNs span […]
Will SQL Server go offline if it loses network connectivity to SAN where master and msdb system databases reside?
Question : I have a setup where 3 servers combined into Availability Group All 3 servers have local directly attached […]
Migrating system and user databases to a new server by moving the LUN
Question : I have to replace a server. The system and user databases all reside on the E: drive which […]
How is SQL Sever able to improve the performance using partitioned tables in a SAN storage environment?
Question : Link: https://docs.microsoft.com/en-us/sql/relational-databases/partitions/partitioned-tables-and-indexes?view=sql-server-ver15#:~:text=SQL%20Server%20supports%20table%20and,are%20mapped%20into%20individual%20partitions. SQL Server supports table and index partitioning. The data of partitioned tables and indexes is divided […]
Oracle vs SQL Server, 4k vs 16k block sizes
Question : I was reading over these 3 articles: At my last company we only used MS SQL Server and […]