I have a fairly large transactional database (100GB) with a lot of users. The database access is solely via stored procs that make heavy use of temp tables, table variables, cursors and other fun things.
I'm trying it out on a new box in an effort to boost the performance. The new box has 5 separate physical hard drives. I am struggling trying to come up with an optimal setup (mostly though ignorance, I am a c# dev normally). So far, I got the following:
Drive C: OS, SQL install, TempDB log Drive D: Database data Drive E: Database log Drive F: TempDB data Drive G: Databases indexes
Am I going about the right way? Any glaring mistakes?