Drawbacks of putting transaction log on system drive

Hi,
I use MS SQL Server 2000 SP3a on MS Windows 2000 Advanced Server (latest).
Would I come across any drawbacks if I put all transaction log files of a
database onto the system (OS installation) drive along with a page file and
maybe the tempdb? Most of the load in my database is due to read operations.
-- Many thanks, Oskar.Oskar wrote:
> Hi,
> I use MS SQL Server 2000 SP3a on MS Windows 2000 Advanced Server (latest).
> Would I come across any drawbacks if I put all transaction log files of a
> database onto the system (OS installation) drive along with a page file an
d
> maybe the tempdb? Most of the load in my database is due to read operation
s.
> -- Many thanks, Oskar.
>
Hi Oskar
There will most likely be a performance hit the more files you put on
the same drive, but if it will be noticable or a problem is hard to say
without knowing your load and application. The best advice it to test it
as good as you can and then make your decicion based on your tests.
Regards
Steen Schlüter Persson
Database Administrator / System Administrator

Drawbacks of putting transaction log on system drive

Hi,
I use MS SQL Server 2000 SP3a on MS Windows 2000 Advanced Server (latest).
Would I come across any drawbacks if I put all transaction log files of a
database onto the system (OS installation) drive along with a page file and
maybe the tempdb? Most of the load in my database is due to read operations.
-- Many thanks, Oskar.Oskar wrote:
> Hi,
> I use MS SQL Server 2000 SP3a on MS Windows 2000 Advanced Server (latest).
> Would I come across any drawbacks if I put all transaction log files of a
> database onto the system (OS installation) drive along with a page file and
> maybe the tempdb? Most of the load in my database is due to read operations.
> -- Many thanks, Oskar.
>
Hi Oskar
There will most likely be a performance hit the more files you put on
the same drive, but if it will be noticable or a problem is hard to say
without knowing your load and application. The best advice it to test it
as good as you can and then make your decicion based on your tests.
Regards
Steen Schlüter Persson
Database Administrator / System Administrator

download link of Yukon

Hi ,
need a download link of latest build of YUKON
Thanks
ARRExpress edition can be downloaded from
http://www.microsoft.com/downloads/details.aspx?FamilyID=62b348bb-0458-4203-bb03-8be49e16e6cd&displaylang=en.
Developer edition is available for MSDN subscribers.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"Aju" <ajuonline@.yahoo.com> wrote in message
news:%23KkDrzPBFHA.2640@.TK2MSFTNGP14.phx.gbl...
> Hi ,
> need a download link of latest build of YUKON
> Thanks
> ARR
>

download link of Yukon

Hi ,
need a download link of latest build of YUKON
Thanks
ARR
Express edition can be downloaded from
http://www.microsoft.com/downloads/d...isplaylang=en.
Developer edition is available for MSDN subscribers.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"Aju" <ajuonline@.yahoo.com> wrote in message
news:%23KkDrzPBFHA.2640@.TK2MSFTNGP14.phx.gbl...
> Hi ,
> need a download link of latest build of YUKON
> Thanks
> ARR
>

download link of Yukon

Hi ,
need a download link of latest build of YUKON
Thanks
ARRExpress edition can be downloaded from
http://www.microsoft.com/downloads/...displaylang=en.
Developer edition is available for MSDN subscribers.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"Aju" <ajuonline@.yahoo.com> wrote in message
news:%23KkDrzPBFHA.2640@.TK2MSFTNGP14.phx.gbl...
> Hi ,
> need a download link of latest build of YUKON
> Thanks
> ARR
>

Does the RS standard edition / Enterprise edition has the same version number as the devel

Does the RS standard edition or Enterprise edition has the same version
number as developer edition? The latest version number from the developer
edition is 8.00.878.00. I want to know if other RS editions has the same
version number. This information is important to me because I want to make
sure our version checking program will work for all editions.
Thanks,
LianghongYes, the version number is the same for all editions of RS.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Guo, Lianghong" <lhguo@.fs.com> wrote in message
news:OJ8QXI8gEHA.1656@.TK2MSFTNGP09.phx.gbl...
> Does the RS standard edition or Enterprise edition has the same version
> number as developer edition? The latest version number from the developer
> edition is 8.00.878.00. I want to know if other RS editions has the same
> version number. This information is important to me because I want to make
> sure our version checking program will work for all editions.
> Thanks,
> Lianghong
>