SQL Server Best Practices
Jump to navigation
Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
SQL Server Best Practices
- Put the SQL database on a separate drive, not the C drive
- By default, SQL places the database in program files on C, but this is not a good location. C drive is already busy handling the operating system, so best to put on a separate drive.
- Put SQL database on a separate physical drive
- This will provide best performance by not competing with the main OS drive running the SQL server program
- Always provide maximum RAM memory that you can provide
- Ram memory tends to be inexpensive and always best to have plenty of memory for SQL
- See this site for info on how or search for this info as it may change: https://technet.microsoft.com/en-us/library/ms191144(v=sql.105).aspx
- More even more performance the following will give good cost performance benefits:
- Use SSD or fast drives if you need ultimate performance and speed
- Have a third drive for the temp table databases. this could be SSD also for fast performance.