Reply to thread

Message

<blockquote data-quote="spectre72" data-source="post: 1838266" data-attributes="member: 18885">I have spent quite a few years developing and maintaining reporting/OLAP systems in both Oracle and SQL Server.It sounds like new hardware is a definite need.From my experiences I have found better performance when I have been able to remove the database from the application server.&nbsp; Sometimes this is not possible due to limitations in money or the application but when possible it really seems to boost performance.My next question is on the disks...Are you planning on OS mirroring or Hardware mirroring?I am assuming Hardware, but I also know the limitations of funding.I have never found OS mirroring to be very efficient in the Windows world.Again, a bad assumption since you could be running any number of different OS's.On a DB server I have found that disk subsystems are usually the cause of most of the grief you will encounter.&nbsp; Many times you will see bad performance and in the end you will trace it back to the disk subsystem even though that is not where you would have thought it was.The other killer for performance that I work with all the time is sub-optimal design.&nbsp; SQL that causes iterative full table scans, indexes that don't work as expected, ...etc.&nbsp; This is a killer and one that will cause the best hardware to come to seem incredibly slow.&nbsp; Happens to me all the time. <img src="http://www.enworld.org/forum/images/smilies/nervous.png"&nbsp; class="smilie" loading="lazy" alt=":heh:" title="Nervous Laugh&nbsp; &nbsp; :heh:" data-shortname=":heh:" /> I am also sure that everyone who is working on this project is putting 500% into it so don't take my comments as anything other than comments.&nbsp; I have quite a few years building and maintaining DB servers in the hundreds of GB size (on Windows&nbsp; <img src="https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f615.png" class="smilie smilie--emoji" loading="lazy" width="64" height="64" alt=":confused:" title="Confused&nbsp; &nbsp; :confused:"&nbsp; data-smilie="5"data-shortname=":confused:" /> ) so I just wanted to throw some things out for you to think about.Good luck, and may your downtime be minimal....</blockquote>

[QUOTE="spectre72, post: 1838266, member: 18885"] I have spent quite a few years developing and maintaining reporting/OLAP systems in both Oracle and SQL Server. It sounds like new hardware is a definite need. From my experiences I have found better performance when I have been able to remove the database from the application server. Sometimes this is not possible due to limitations in money or the application but when possible it really seems to boost performance. My next question is on the disks... Are you planning on OS mirroring or Hardware mirroring? I am assuming Hardware, but I also know the limitations of funding. I have never found OS mirroring to be very efficient in the Windows world. Again, a bad assumption since you could be running any number of different OS's. On a DB server I have found that disk subsystems are usually the cause of most of the grief you will encounter. Many times you will see bad performance and in the end you will trace it back to the disk subsystem even though that is not where you would have thought it was. The other killer for performance that I work with all the time is sub-optimal design. SQL that causes iterative full table scans, indexes that don't work as expected, ...etc. This is a killer and one that will cause the best hardware to come to seem incredibly slow. Happens to me all the time. :heh: I am also sure that everyone who is working on this project is putting 500% into it so don't take my comments as anything other than comments. I have quite a few years building and maintaining DB servers in the hundreds of GB size (on Windows :confused: ) so I just wanted to throw some things out for you to think about. Good luck, and may your downtime be minimal.... [/QUOTE]

Verification