What are SQL Server 'Binaries'? 1

[Ovatvvon]

I keep hearing the term "Binaries" used. (i.e. Install the binaries on a separate disk - other than the operating system.)

Are Binaries simply the installation files for SQL Server? Or are they something else?

Can anyone help?

-Ovatvvon :-Q

 

[mrdenny]

The binaries are the exe, dll, ocx, help files, etc that are normally installed in c:\Program Files\Microsoft SQL Server\MSSQL\Binn\

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[Ovatvvon]

Thanks.
So does it actually boost performance to place the binaries on a separate drive or scsi channel than the operating system and database files - so it is on its own?

Or is it merely important to have it separate from the MDF's and LDF's? why would one want to place the binaries on their own drive?


-Ovatvvon :-Q

 

[mrdenny]

The binaries can be on the same drive as the OS. However they should be seperate from all the database files.

I place the binaries on there own drive so that writting to the page file doesn't impact reading the binary files.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com