The MS SQL Server can be used to tackle intense workloads with clinical efficiency provided the hardware infrastructure is in place. Now if your application needs to service a cross department, large user environment or is a client facing application accessed by thousands, it needs to be run on proper hardware. Let’s look at some of key hardware recommendations that can help jazz up the performance of your SQL Server application.
Consider Adding as Much Memory as Possible
Most database administrators are aware about the fact that adding more Random access memory goes a long way in improving the performance of a SQL Server. The server you use to run a SQL Server instance should have free slots to add memory modules whenever needed. Ideally 16GB of RAM is typically needed for efficient running of a SQL Server enterprise application. However as workload increases you should look at upgrading it considerably.
Factor the Disk Drives you Use
The kind of disk drives that you use is entirely dependent on your requirement and if possible solid state disk drives should be used. Again instead of using a single large disk several disks of smaller size but with fast read and write speeds should be used.
Opt for a Dedicated Server with fast processors and multiple cores
Processors and cores from the backbone of an optimized and quick performing SQL Server application. However besides investing top of the line processors, you need to ensure that the server you use for running a SQL Server instance should be dedicated. You should not run other programs on it as it will over burden the system. A SQL Server instance includes several services which need a lot of memory space and processor time for running properly. Sharing a system with other application is a sure shot recipe for a slow SQL application and can drastically slow down large queries. Thus always make sure that you do not use a shared server to run a SQL Server instance.
Disk Mirroring cannot be a panacea for avoiding an investment in a data recovery tool
Some companies who have introduced disk mirroring as a cornerstone of their data recovery plans seem to believe that they would never need the service of a data recovery tool. However this assumption is far from correct and there are several fault conditions wherein a mirroring system may prove inadequate. Hence it is prudent for companies to invest in a top of the line sql recovery tool like the DataNumen SQL Recovery application. It saves your data on a day when you are going to be most stressed out and possibly wondering why your mirroring and logged backup mechanisms failed to work as needed. From saving your company from a reputation loss to ensuring complete recovery of your data, in correct shape to the last record, this tool can act as lifesaver in the event of a complete SQL crash.
Alan Chen is President & Chairman of DataNumen, Inc., which is the world leader in data recovery technologies, including access recovery and sql recovery software products. For more information visit https://www.datanumen.com/