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.
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.googlegr oups.com...
> Hey J,
> Have you tried this switch? and is it making a difference?
> Myles
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment