SQL Server plus small files

Posted by user1467163 on Server Fault See other posts from Server Fault or by user1467163
Published on 2012-07-05T20:57:45Z Indexed on 2012/07/05 21:17 UTC
Read the original article Hit count: 230

I have a MSSQL server, 3 volumes, that runs some processes that seem to take way too long. One of these processes reads in a zip file, then writes to a database based on what's in the zip file.... for each record. I have 2 volumes in use and am creating the third- so I am trying to plan how to do this. OS has to remain on vol. 1. The TLogs should probably go on the new volume and the mdf's on the existing vol.2.. Do I put the file store on the volume with the MDF's so they don't interfere with the TLog writes, or with the TLogs so they don't interfere with the TLog flush to the MDFs? I know it's best to have more servers / volumes but I have to make do with whats on hand for now. I appreciate any suggestions.

© Server Fault or respective owner

Related posts about sql-server-2005

Related posts about filesystems