I need documentation re: dedicated SQL Server

I am searching for some reliable-source documentation regarding why SQL
Server should be run on a dedicated server. Can anyone provide me with
links to such documentation?
mkerrigan@.ktoys.com wrote:
> I am searching for some reliable-source documentation regarding why
> SQL Server should be run on a dedicated server. Can anyone provide
> me with links to such documentation?
It's about resources: cpu, memory, disk. Do you need to maximize the
resources your database server has a particular piece of hardware or do
you (more like "can you") afford to have SQL Server share resources with
other applications?
It's better to run SQL Server in isolation, but if your database is
small enough or does not have a lot of activity, then your server
hardware may suffice running more than one service.
David Gugick - SQL Server MVP
Quest Software
|||David Gugick wrote:
> mkerrigan@.ktoys.com wrote:
> It's about resources: cpu, memory, disk. Do you need to maximize the
> resources your database server has a particular piece of hardware or do
> you (more like "can you") afford to have SQL Server share resources with
> other applications?
> It's better to run SQL Server in isolation, but if your database is
> small enough or does not have a lot of activity, then your server
> hardware may suffice running more than one service.
>
The server is running approximately 30 databases with various rates of
activity, some users coming in from out of state. The largest database
so far is about 2 GB and these will all grow. Currently the server is
also running Backup Exec's SQL Server engine as well as some other
applications and services. We are trying to justify dedicating a
server to just using SQL Server, and the higher-ups want to see
documentation, preferably from Microsoft. I have been unable to find
anything specific.
|||mkerrigan@.ktoys.com wrote:
> David Gugick wrote:
> The server is running approximately 30 databases with various rates of
> activity, some users coming in from out of state. The largest
> database so far is about 2 GB and these will all grow. Currently the
> server is also running Backup Exec's SQL Server engine as well as
> some other applications and services. We are trying to justify
> dedicating a server to just using SQL Server, and the higher-ups want
> to see documentation, preferably from Microsoft. I have been unable
> to find anything specific.
I don't really think this is a "documentation" decision. If you
eliminate all costs involved, it's easy to justify using a dedicated box
for SQL Server. Once you consider the added costs of another box, an
additional OS, added maintenance and support, these are certainly
concerns that must be considered. What's most important here is what
effect these other apps/services are having on your SQL Server
operational performance. You really need to make this decision based on
you particular environment and requirements. I would encourage you to
not make this decision based solely on someone's opinion - including
mine :-)
If you need help figuring out what effect these other services are
having on SQL Server, then start a new thread with that question and I'm
sure you'll get a lot of system profiling suggestions.
David Gugick - SQL Server MVP
Quest Software