Petri IT Knowledgebase Forums
 

Petri.co.il forums Home Forums Start Page Forums Frequently Asked Questions FAQ Member List Members List
Go Back   Petri IT Knowledgebase Forums > Databases > SQL 2005
Petri.co.il is happy to award auglan the title of Most Valuable Member !!!
Register Calendar Calendar Search Petri IT Knowledgebase Forums Search Todays Posts Today's Posts Mark Forums Read

Notices

SQL Server 2005- File storage for non-DB files

SQL Server 2005- File storage for non-DB files

this thread has 0 replies and has been viewed 1112 times

Closed Thread
 
Thread Tools Search this Thread Display Modes
  #1  
Old 6th August 2012, 18:42
dspahn dspahn is offline
Casual
Casual
 
 Join Date: Aug 2012
  6 month star
 Posts: 3
 Reputation: dspahn is on a distinguished road (10)
Lightbulb SQL Server 2005- File storage for non-DB files

I've come acros a scenario a number of time in the past few years, and have not been able to get a good answer. I work with production systems that process a lot of sale transactions. My current setup uses MS SQL Server 2005. I have a Dell PE2950 with six drives- It's maxed out. They are all set up as RAID-1 mirrors of two drives each- three volumes total. OS is stored on the first volume... and then it gets unclear what the best configuration is. I have the database data files, and I have the translogs. Those must go on separate physical volumes.... but then there are more types of data that must go on this server. There are input and output files that just can't cut it if moved to a different server- The performance hit brings every process down to a crawl if I try other locations. The output files are all small PDF's- we must generate a few hundred a day. The input files are mostly zip files, which the application must open, process, and archive. The PDF's generally are 100K or less, with a few exceptions per day. The ZIP files are less than 200KB. What is the most optimal way to organize the files? My thought was to leave the MDF's, PDF's and ZIP's on one of the two remaining volumes and move the translogs to a dedicated drive. Should I set custom format options on the drive holding input and output files- a small allocation unit size? Any advice you can provide will be helpful.
Thanks!
Closed Thread


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Ready Only files on Storage Server 2008 jeffgrewal Windows Server 2008 / 2008 R2 3 5th January 2011 16:20
Mom 2005 script / Check on file Carlson General Scripting 3 20th August 2009 20:51
Image files continuously become corrupt on our file server meganeight Misc 2 3rd August 2009 22:11
SQL Server upgrade failure (SQL Server 2005 Express Edition to SQL Server 2005) Taw_Jackson Misc 5 11th March 2009 19:26
How can I find out who moved files/folders on our file server? a2thed Windows Server 2000 / 2003 5 8th January 2009 00:32


All times are GMT +3. The time now is 21:09.

Steel Blue 3.5.4 vBulletin Style ©2006 vBEnhanced
Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
 

Valid XHTML 1.0!   Valid CSS!

Copyright 2005 Daniel Petri