Email Alerts
-
Step 2: Understand your workload
Before you make a hardware decision, you must fully understand your workload and capacity needs. Contributor Hilary Cotter offers his advice. Step-by-Step Guide
-
Step 10: Optimize CPU activity and speed
You must study processor workload, queue length and storage to optimize your SQL Server hardware resources. Step-by-Step Guide
-
Step 6: Take advantage of storage area networks
Storage area networks (SANs) can offer much better performance than local storage. Find out how they can benefit your SQL Server environment. Step-by-Step Guide
-
Step 5: Take advantage of 64-bit
You may benefit from a 20% improvement in performance using 64-bit over a 32-bit architecture. Contributor Hilary Cotter explains. Step-by-Step Guide
-
Step 9: Choose and optimize your disks wisely
Choosing the proper disk type, optimizing disk speed and sizing your disks for future database growth are key elements to ideal hardware performance. Learn more in this tip. Step-by-Step Guide
-
Step 8: Use separate disk controllers
Contributor Hilary Cotter explains why you should have separate controllers for each file group. Step-by-Step Guide
-
Step 4: Choose a reliable hardware brand
Contributor Hilary Cotter explains what to look for in a hardware vendor. Step-by-Step Guide
-
Step 3: Know your memory support limitations
Find out what is the maximum available memory for the various editions of SQL Server. Step-by-Step Guide
-
Step 7: Properly configure your RAID arrays
Contributor Hilary Cotter discusses the best RAID configurations for your SQL Server. Step-by-Step Guide
-
Converting date format in flat files
Ask the Expert