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 |
|
Elvy
Starting Member
1 Post |
 Posted - 2007-03-10 : 22:51:58
|
| I am not running an sql server, its a pvpgn server for Diablo II. Just like any other server but this is run on my computer. Currently it is running on my hard drive (C:). Here is my question. If I get a secondary slave drive and put the server files on there where the windows os files are not run and there is nothing running on the drive but the server, will that increase the performance of the server? Or will this even work? |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-03-11 : 01:25:35
|
| I can only speak for SQL Server where performance-increasing steps are generally:Putting the database on a different drive to the operating system, preferably a drive dedicated to the database, increases performance.Putting the Data and Logs on separate drives increases performance further.Putting the TEMPDB and Backups on yet more drives increases the performance further.Splitting the database into multiple "files" on separate drives increases performance further.Kristen |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-03-11 : 18:49:19
|
Kristen, you do realize Diablo II is a game, don't you?  Generaly you'll get a bit of performance if you put your files on a non OS drive._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-03-12 : 02:36:22
|
| It also depends on what type of file system your drive has? NTFS or FAT32? (especially for SQL Server 2005)Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-03-12 : 08:36:46
|
| "you do realize Diablo II is a game, don't you?"SQL2k5 has games now?! |
|
|
|
|
|
|
Server performance question!