Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
redbrad0
Posting Yak Master
176 Posts |
 Posted - 2005-03-30 : 14:19:37
|
| I am about to upgrade one of my SQL Servers for database performance. I need to know the best setup for the server.There is only one database on this SQL Box and has one very active table. The main table has records adding/editing/deleteing/selecting basically every could seconds. This main table also has Full Text enabled on it and has over 1 million records but will be growing to 5 million in the next month. I am no DBA by any means so I could be wrong in my options of setup.1. Server A runs all the main tables while Server B has this one table in it that is linked and full text running on it.2. Server A has all tables in its SQL Server and Server B just is running the Full Text on the main table.3. Just run one server and just put a ton of ram and processor speed in it.I also read somewhere that it is best to have your log files writing to a different HD then the MDF file. Is that correct? And if so would it be best if full text was stored and written to a third HD if I only used one server.Quality NT Web Hosting & Design |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2005-03-31 : 03:58:25
|
| Yes, you should see some improvement from seperating your logs and data onto seperate physical disks. How physically big is your table? Could you split it into smaller tables? History and current data maybe? Or could you have a shipped or replicated environment on which to do your reporting ?-------Moo. :) |
 |
|
|
redbrad0
Posting Yak Master
176 Posts |
Posted - 2005-03-31 : 19:15:09
|
| Actually not really a way to split up the big table because it is all current data. Would it be better to have Full Text on a different drive also so basically 4 drives... windows... log.. mdf.. ft?Quality NT Web Hosting & Design |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-03-31 : 20:50:27
|
| That could give you significant performance increases. Have you looked at perfmon though to see if you're having any disk wait times?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
Best Setup for SQL Server