Question : We have two standalone servers with local storage. Based on our needs we have determined that we need […]
Tag: san
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 […]
Slow SQL Server authentication, but fast SAN, fast querying?
Question : I am asking you after days of research but I think I don’t have required skills to understand […]