InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 06:57:53 GMT20http://www.sqlservercentral.com/Forums/Topic874480-377-1.aspxDepending on your I/O needs too, SQL Server can be a bit of a resource hog. If you have SQL Server 2008, you can use Resource Governor though to help out with any issues on that end. A 25 GB database isn't that big, but you also need to consider its growth rate too. It depends on your hardware set up also as I don't know how big your drives are or how fast the boxes are.Good points about security too as SysAdmins, Network Admins, etc. are going to need access to the box. If it's sensitive information (e.g. HR database), then that should be on its own box regardless as the less people with access to the box in any way, shape, or form, the better.Tue, 10 Aug 2010 17:11:11 GMTblackbirdhttp://www.sqlservercentral.com/Forums/Topic874480-377-1.aspxI tried making making this argument for many of the reasons that were suggested in this thread and my advise was taken during a consolidation exercise.I had one poorly designed unstable Database, etc. THis Database was a revenue generated.The audience were Network Admin's so I tried to make and analogy.You want to make sure that the Databases that you place a a Server Play nice in the Sandbox together.It respectfully stated that if you put an unstable resource hog on a Server with other mission critical Databases then you put your Business at risk. Sat, 13 Mar 2010 21:35:32 GMTWelsh Corgihttp://www.sqlservercentral.com/Forums/Topic874480-377-1.aspxI tried making making this argument for many of the reasons that were suggested in this thread and my advise was taken during a consolidation exercise.I had one poorly designed unstable Database, etc. THis Database was a revenue generated.The audience were Network Admin's so I tried to make and analogy.You want to make sure that you Databases that you place a a Server Play nice in the Sandbox together.It stated that if you put an unstable resource hog on a Server with other mission critical Databases then you put your Business at risk. Sat, 13 Mar 2010 21:34:19 GMTWelsh Corgihttp://www.sqlservercentral.com/Forums/Topic874480-377-1.aspx[quote][b]scott.trick (3/2/2010)[/b][hr]Thanks for the responses... much appreciated![/quote]You're welcome.Tue, 02 Mar 2010 09:23:29 GMTSQLRNNRhttp://www.sqlservercentral.com/Forums/Topic874480-377-1.aspxThanks for the responses... much appreciated!Tue, 02 Mar 2010 07:53:08 GMTScott T.http://www.sqlservercentral.com/Forums/Topic874480-377-1.aspxdbychen gave some good responses. In addition I would add easier troubleshooting (no other apps interfering).Mon, 01 Mar 2010 10:11:16 GMTSQLRNNRhttp://www.sqlservercentral.com/Forums/Topic874480-377-1.aspxWhether it requires a dedicated server for the database, you need to consider its application importance, security, availability, performance, and manageability. Here are some thoughts for having a dedicated database server:Application Importance - If this database supports a critical application, why can't you afford a dedicated server for it to generate more revenue or benefits for the company?:-PSecurity - If you want to avoid unrelated people to potentially view the data, dedicated server is a choice.Availability - The other database instance(s) on the same server may be unstable and requires frequent server reboot that reduces your database availability.Performance - Your database instance may compete computer resources with other instances that may cause undesired performance to your database.Manageability - It require more coordination for many things in a shared environment and this coordination is not always an easy task.Mon, 01 Mar 2010 09:50:14 GMTdbychenhttp://www.sqlservercentral.com/Forums/Topic874480-377-1.aspxDedicated server? Do you mean a single instance (default or named) hosting a single database? Here are some benefits of a separate instance:Can allocate specific memory to that instanceCan control access thru its defined port and firewall rulesBecause there's separate services, it can be serviced separate from other databases on the server (or vice versa)Can have specific configuration settings for this instance, for security/performance/maintenanceThere's just a few, probably plenty more to think about.Mon, 01 Mar 2010 09:18:01 GMTSQLDCHhttp://www.sqlservercentral.com/Forums/Topic874480-377-1.aspxI need to come up with the benefits of having a dedicated SQL Server and thought I would ask here to make sure I don't forget anything.We currently have a 25GB database with up to 200 users.Please respond with as many benefits why a company would use a dedicated server rather than sharing it with many other databases.Thank You!Mon, 01 Mar 2010 09:08:43 GMTScott T.