Click here to Skip to main content
       

System Admin

 
GeneralRe: auto gen shortcut on dev machine.. PinmvpRichard MacCutchan21-Jun-12 6:11 
QuestionDetecting blocked connections PinmemberFernando A. Gomez F.7-Jun-12 15:29 
AnswerRe: Detecting blocked connections PinmemberPeter_in_27807-Jun-12 16:27 
GeneralRe: Detecting blocked connections PinmemberFernando A. Gomez F.7-Jun-12 19:28 
QuestionStrange difference between [Del] and [Shift][Del] in Windows Explorer PinmemberBernhard Hiller1-Jun-12 4:24 
AnswerRe: Strange difference between [Del] and [Shift][Del] in Windows Explorer PinmemberJörgen Andersson1-Jun-12 7:11 
AnswerRe: Strange difference between [Del] and [Shift][Del] in Windows Explorer Pinmembermark merrens1-Jun-12 7:23 
QuestionOff-Server Storage Faster? Pinmemberphil241525-May-12 5:50 
Ok, maybe some cleverer people than myself can help with this one. We have a business-critical application which runs with a MSSQL backend and generates a lot of documents (letters, etc., in Word and PDF format). At present the documents are just stored in a share on the same server as the database, with the filenames stored in a table and the documents called directly from the application on client computers when requested (I didn't design this, by the way!).
 
A little while ago, due to storage space issues on the server, I decided to move the documents off the server and onto a dedicated NAS (Netgear ReadyNAS 2100) with lots of capacity rather than just beef up the server's disk space. My reasoning was that the network load would be spread between the server and the NAS, instead of the server's NIC handling both database and document traffic. In practice, the performance of opening documents actually decreased dramatically for those departments which I migrated to the NAS, to the point where I halted the migration. Sometimes documents on the NAS open perfectly quickly, and a user will have no speed issues for several minutes or hours. Then, suddenly, one file will take literally a minute or more to open. These are only small Word documents and I'm only talking about a few dozen users who have been migrated.
 
ANYWAY, what I'm getting to is that it's time to replace all of this hardware anyway. I'm about to purchase a very powerful, fast server to replace the DB server. Reviews suggest that its I/O performance is exceptional. But I was also going to purchase a new, high-performance NAS and stick with the topology I've already described. My theory is that the speed issues are being caused by some deep-level communication problem between the Netgear ReadyNAS and the clients, which neither they nor I have been able to get to the bottom of. It still seems like sound reasoning to me that separating database and documents will result in a spread network load and increased performance. Am I wrong?
 
I don't know the technicalities involved in opening a document in a network share. Is it perhaps the case that the process of establishing a connection to the share and opening a file, at least the first time in a session, is much slower than opening the same file stored on the database server, to which a 'connection' is already established due to the user having been using the database?
 
Any discussion or advice on this topic would be greatly appreciated. If stuffing the database server full of disks and keeping the files on there is going to be the fastest solution, I'll save a whole lot of money!
 
Sorry for the wall of text - thanks!
AnswerRe: Off-Server Storage Faster? PinmvpDave Kreskowiak1-Jun-12 5:15 
Questionwayne nucleus point of sale configuration documents or technical support from wayne nucleus PinmemberMuhammad Rashid Khan23-May-12 22:27 
AnswerRe: wayne nucleus point of sale configuration documents or technical support from wayne nucleus PinmvpRichard MacCutchan23-May-12 23:21 
AnswerRe: wayne nucleus point of sale configuration documents or technical support from wayne nucleus PinmvpRichard MacCutchan24-May-12 0:39 
GeneralMessage Automatically Removed Pinmemberpaiaw11-May-12 22:13 
GeneralRe: How to Create and Use a Windows 7 Password Reset USB PinmvpRichard MacCutchan22-May-12 23:52 
QuestionWindows detected a hard disk problem Pinmemberberba3-May-12 2:13 
AnswerRe: Windows detected a hard disk problem PinmvpRichard MacCutchan3-May-12 2:31 
QuestionData acquisition from audio card PinmemberHibiscusblau25-Apr-12 1:19 
AnswerRe: Data acquisition from audio card PinmemberChris Quinn16-Jul-12 5:40 
QuestionMore Of A Tip Than A Question PinmemberRoger Wright24-Apr-12 14:13 
AnswerRe: More Of A Tip Than A Question PinmemberJörgen Andersson24-Apr-12 23:28 
AnswerRe: More Of A Tip Than A Question PinprotectorPete O'Hanlon25-Apr-12 0:28 
GeneralRe: More Of A Tip Than A Question PinmemberRoger Wright25-Apr-12 4:14 
QuestionA Flurry Of "Returned Mail" [modified] PinmemberRoger Wright5-Apr-12 21:06 
AnswerRe: A Flurry Of "Returned Mail" Pinmember Randor 7-Apr-12 20:13 
AnswerRe: A Flurry Of "Returned Mail" PinmvpLuc Pattyn8-Apr-12 3:13 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web04 | 2.8.141216.1 | Last Updated 4 Dec 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid