In this article we look at SQL Server implementation in mid to large sized firms and look at the key requirement for substantial memory to improve the performance of the database server.
Opting for a database solution in a mid to large sized firm is a complex process. It is even more difficult if you are updating from a legacy database system or upgrading from an open source solution to SQL Server. There are several factors to keep in mind, starting from licensing costs to the kind of hardware you would need. The SQL Server database solution is available in different editions and several licensing options exist for different needs. Let’s explore the topic in depth.
A Quick Look at Licensing Options
At the very outset you need to choose between a physical server dedicated to running the SQL Server engine or opting for a virtual machine. In case you choose to opt for a virtual machine licensing costs are significantly low and you are billed per guest. However if you are looking to run a dedicated physical machine for the database server, do factor in a licensing cost running into several thousand dollars. In case you opt for the enterprise edition, licensing costs are likely to skyrocket.
Hardware too needs to be top of the line
If you are investing in a physical machine, you need to ensure you get the right hardware to run the power SQL Server application. Opt for the fastest processors present around and build a machine which is optimized to run database applications with ease. Ideally you should connect with a hardware vendor who has specialization in deploying on site server racks.
Invest in Memory – More the merrier
On a ballpark figure, the cost of licensing is going set you back by several thousands of dollars if you have invested in a standard or enterprise edition with a physical multi-core system. In comparison to software costs, hardware costs are likely to be miniscule. To get more juice out of your hardware and keep the database performance on track, invest in large amount of TempDB memory. We would even suggest opting for two SSDs of 320GB each.
Even the latest SQL Server edition can crash due to logical errors
In case you are running the latest edition of SQL Server on a top of the line hardware stack, it is quite easy to become complacent and believe the system will not crash. However such complacency can prove hazardous as every SQL Server instance is susceptible to crashes under certain conditions. Hence it is prudent to keep a sql recovery tool like DataNumen SQL Recovery application handy to tackle such emergencies. From a thoroughly corrupted MDF file to a compromised file lying on a virtual drive, this application can extract the records without much ado. For system administrators, the tool comes with a command line tool for easy access and offer batch recovery too.
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/