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 |
|
trancetopia
Starting Member
4 Posts |
 Posted - 2005-08-26 : 06:02:30
|
| Hi Folks,The company I am working for has actually signed off a dual xeon 3.0Ghz server to store our reporting data on. This data will be be accessed by a new online reporting tool that we will develop but I have some concerns that are quite literally making me feel disappointed to say the least.There will be up to 100 users accessing this data per day and the data is quite considerable in volume.Apparently us having this server is not so clear cut. I seems to be provisioned as a file server for another part of the company so we have been allocated on 50GB of HDD space.We will need to get this increased but I'm worried about the performance of SQL Server because of this other servers other intended uses.I am fearing that this allocated HDD space we are going to get is going to be on one drive.The config I wanted was to have SQL server on c:, databases on d: and tran logs on e: for example. Also I was going to allocate the majority of the servers memory to SQL Server but if this server is going to be shared, I'm not going to be able to do this and this server will only perform a % of what we need it to perform.There will be a massive amount of db activity on this server so will having this server used as a file server by approx 400 people cause me serious problems.Do I reject the server and tell the company they are having a laugh at my expense or am I worrying about nothing?Any advice would be really appreciated.Many thanks,Paul-----Paul |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-08-26 : 08:35:39
|
| be weary of this. i would rather a bunch of little dedicated machines than one big hog running a bunch of applications. if the machine is going to be busy as a file server, and everyone knows how file servers get abused, sql is going to take a hit. and if sql gets hung up people are going to have problems getting to their files. go back to them and make your case for a seperate box even if it is not your dream machine. I do not always win but I always go down swinging.====================================================Regards,Sean RoussyThank you, drive through |
 |
|
|
|
|
|
New Server - Advice urgently needed