Performance

One of our system engineers seems to believe that MSSQLServer's performance
will be the same if SQLServer was installed on the same drive as the OS. He
believes that the entire OS is loaded in memory (lets say 6 gig physical me
mory) and SQLServer will ut
ilize the entire the drive. BTW: The OS drive is also the location of the V
irtual Memory.
Has anyone tested the performance when SQLServer is installed on the OS Driv
e compared to that if it installed on its own drive.It will make no difference; the executable itself will be loaded into
memory. What WILL make a difference is placement of data and log files on
different devices. Please refer to "Inside SQL Server" for a good
discussion of this topic.
"molonede" <anonymous@.discussions.microsoft.com> wrote in message
news:102A14DC-430C-4C7C-A3EC-2FC874DF0FF9@.microsoft.com...
> One of our system engineers seems to believe that MSSQLServer's
performance will be the same if SQLServer was installed on the same drive as
the OS. He believes that the entire OS is loaded in memory (lets say 6 gig
physical memory) and SQLServer will utilize the entire the drive. BTW: The
OS drive is also the location of the Virtual Memory.
> Has anyone tested the performance when SQLServer is installed on the OS
Drive compared to that if it installed on its own drive.|||Where would I find this reference material?
-- Adam Machanic wrote: --
It will make no difference; the executable itself will be loaded into
memory. What WILL make a difference is placement of data and log files on
different devices. Please refer to "Inside SQL Server" for a good
discussion of this topic.
"molonede" <anonymous@.discussions.microsoft.com> wrote in message
news:102A14DC-430C-4C7C-A3EC-2FC874DF0FF9@.microsoft.com...
> One of our system engineers seems to believe that MSSQLServer's
performance will be the same if SQLServer was installed on the same drive as
the OS. He believes that the entire OS is loaded in memory (lets say 6 gig
physical memory) and SQLServer will utilize the entire the drive. BTW: The
OS drive is also the location of the Virtual Memory.[vbcol=seagreen]
Drive compared to that if it installed on its own drive.|||It's a book, written by Kalen Delaney. So any good bookstore. I apologize
for not being more specific in my original post.
"molonede" <anonymous@.discussions.microsoft.com> wrote in message
news:B8166487-ED70-47FA-A3F3-D1A50ECB014D@.microsoft.com...
> Where would I find this reference material?
> -- Adam Machanic wrote: --
> It will make no difference; the executable itself will be loaded into
> memory. What WILL make a difference is placement of data and log
files on
> different devices. Please refer to "Inside SQL Server" for a good
> discussion of this topic.
>
> "molonede" <anonymous@.discussions.microsoft.com> wrote in message
> news:102A14DC-430C-4C7C-A3EC-2FC874DF0FF9@.microsoft.com...
> performance will be the same if SQLServer was installed on the same
drive as
> the OS. He believes that the entire OS is loaded in memory (lets say
6 gig
> physical memory) and SQLServer will utilize the entire the drive.
BTW: The
> OS drive is also the location of the Virtual Memory.
the OS[vbcol=seagreen]
> Drive compared to that if it installed on its own drive.
>
>|||There's a book called Inside SQL Server 2000, so I imagine that's what's
being referred to here.
This is a little bit out of date since it was written for SQL 7 instead of
SQL 2000, but this is one of the better articles on sql perf that I've found
on the web:
sql7perftune.asp" target="_blank">http://msdn.microsoft.com/library/d...ql7perftune.asp
- Dave
"molonede" <anonymous@.discussions.microsoft.com> wrote in message
news:B8166487-ED70-47FA-A3F3-D1A50ECB014D@.microsoft.com...
> Where would I find this reference material?
> -- Adam Machanic wrote: --
> It will make no difference; the executable itself will be loaded into
> memory. What WILL make a difference is placement of data and log
files on
> different devices. Please refer to "Inside SQL Server" for a good
> discussion of this topic.
>
> "molonede" <anonymous@.discussions.microsoft.com> wrote in message
> news:102A14DC-430C-4C7C-A3EC-2FC874DF0FF9@.microsoft.com...
> performance will be the same if SQLServer was installed on the same
drive as
> the OS. He believes that the entire OS is loaded in memory (lets say
6 gig
> physical memory) and SQLServer will utilize the entire the drive.
BTW: The
> OS drive is also the location of the Virtual Memory.
the OS[vbcol=seagreen]
> Drive compared to that if it installed on its own drive.
>
>