Click here to Skip to main content
15,888,461 members
Home / Discussions / System Admin
   

System Admin

 
GeneralRe: auto gen shortcut on dev machine.. Pin
Richard MacCutchan21-Jun-12 5:11
mveRichard MacCutchan21-Jun-12 5:11 
QuestionDetecting blocked connections Pin
Fernando A. Gomez F.7-Jun-12 14:29
Fernando A. Gomez F.7-Jun-12 14:29 
AnswerRe: Detecting blocked connections Pin
Peter_in_27807-Jun-12 15:27
professionalPeter_in_27807-Jun-12 15:27 
GeneralRe: Detecting blocked connections Pin
Fernando A. Gomez F.7-Jun-12 18:28
Fernando A. Gomez F.7-Jun-12 18:28 
QuestionStrange difference between [Del] and [Shift][Del] in Windows Explorer Pin
Bernhard Hiller1-Jun-12 3:24
Bernhard Hiller1-Jun-12 3:24 
AnswerRe: Strange difference between [Del] and [Shift][Del] in Windows Explorer Pin
Jörgen Andersson1-Jun-12 6:11
professionalJörgen Andersson1-Jun-12 6:11 
AnswerRe: Strange difference between [Del] and [Shift][Del] in Windows Explorer Pin
R. Giskard Reventlov1-Jun-12 6:23
R. Giskard Reventlov1-Jun-12 6:23 
QuestionOff-Server Storage Faster? Pin
phil241525-May-12 4:50
phil241525-May-12 4: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? Pin
Dave Kreskowiak1-Jun-12 4:15
mveDave Kreskowiak1-Jun-12 4:15 
Questionwayne nucleus point of sale configuration documents or technical support from wayne nucleus Pin
Muhammad Rashid Khan23-May-12 21:27
Muhammad Rashid Khan23-May-12 21:27 
AnswerRe: wayne nucleus point of sale configuration documents or technical support from wayne nucleus Pin
Richard MacCutchan23-May-12 22:21
mveRichard MacCutchan23-May-12 22:21 
AnswerRe: wayne nucleus point of sale configuration documents or technical support from wayne nucleus Pin
Richard MacCutchan23-May-12 23:39
mveRichard MacCutchan23-May-12 23:39 
GeneralRe: How to Create and Use a Windows 7 Password Reset USB Pin
Richard MacCutchan22-May-12 22:52
mveRichard MacCutchan22-May-12 22:52 
QuestionWindows detected a hard disk problem Pin
berba3-May-12 1:13
berba3-May-12 1:13 
AnswerRe: Windows detected a hard disk problem Pin
Richard MacCutchan3-May-12 1:31
mveRichard MacCutchan3-May-12 1:31 
QuestionData acquisition from audio card Pin
Hibiscusblau25-Apr-12 0:19
Hibiscusblau25-Apr-12 0:19 
AnswerRe: Data acquisition from audio card Pin
Chris Quinn16-Jul-12 4:40
Chris Quinn16-Jul-12 4:40 
QuestionMore Of A Tip Than A Question Pin
Roger Wright24-Apr-12 13:13
professionalRoger Wright24-Apr-12 13:13 
AnswerRe: More Of A Tip Than A Question Pin
Jörgen Andersson24-Apr-12 22:28
professionalJörgen Andersson24-Apr-12 22:28 
AnswerRe: More Of A Tip Than A Question Pin
Pete O'Hanlon24-Apr-12 23:28
mvePete O'Hanlon24-Apr-12 23:28 
GeneralRe: More Of A Tip Than A Question Pin
Roger Wright25-Apr-12 3:14
professionalRoger Wright25-Apr-12 3:14 
QuestionA Flurry Of "Returned Mail" Pin
Roger Wright5-Apr-12 20:06
professionalRoger Wright5-Apr-12 20:06 
AnswerRe: A Flurry Of "Returned Mail" PinPopular
Randor 7-Apr-12 19:13
professional Randor 7-Apr-12 19:13 
AnswerRe: A Flurry Of "Returned Mail" Pin
Luc Pattyn8-Apr-12 2:13
sitebuilderLuc Pattyn8-Apr-12 2:13 
GeneralRe: A Flurry Of "Returned Mail" Pin
JohnPayton22-May-12 18:39
JohnPayton22-May-12 18:39 

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

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