|
Home > Archive > MS SQL Data Warehousing > July 2005 > -E switch to start SQL Server?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
-E switch to start SQL Server?
|
|
|
| Hi,
What is the -E switch in SQL Server?
(not -e but -E)
I have read this:
SQL Server can allocate 4 extents instead of 1 extent when the -E switch is
specified during startup. Hence, the -E switch enables SQL Server to issue
256 KB I/O even if extent fragmentation exists because of proportional fill.
Does this switch can improve the performance of a data warehouse database?
thanks.
Jerome.
| |
| Myles.Matheson@gmail.com 2005-07-05, 3:23 am |
| Hey J,
Have you tried this switch? and is it making a difference?
Myles
| |
|
| not tested for the moment.
I plan a test this week maybe.
But I want to know your feedback in case of anyone has a bad experience with
it ;)
<Myles.Matheson@gmail.com> wrote in message
news:1120549219.051767.175210@z14g2000cwz.googlegroups.com...
> Hey J,
>
> Have you tried this switch? and is it making a difference?
>
> Myles
>
|
|
|
|
|