|
|
Posted by nitin.goel on 12/20/06 06:56
Here is the H/W and database configuration in this case.
System: - HP Proliant ML 370 G4 Server ( Intel Xeon 3.2 GH on Intel
7520 Chipset; Dual CPU capable )
RAM: - 4 GB DDR2 ECC
HDD: - 2 * 73 GB SCSI ( 15000 RPM ) RAID 0
DB size: - 20 GB
Downtime: - 2 hours a day i.e. morning 5 to 7 AM.
Parallel queries: Parallel Query processing runs only on multiple
processors. In our case only one processor is available to SQL Server.
RAM: it is an OS issue and not of SQL Server. There is no RAM support
specification in SQL Server (EE / SE). By the way, OS used by us is Win
2003 Server EE.
FYI, we have searched MS SQL Server books online + seen the differences
of SE and EE given by MS + asked our local vendor but he knows nothing.
And the queries run by us are select queries with joins on around 5 -1
0 tables. So the picture is still murky and Microsoft is not answering.
And Mr Sommarskog, we do not want anyone to search for us. We are
looking for very specific answers and we will be thankful if someone
can help us (we feel others have also faced same problems.)
Thanks
Nitin Goyal
On Dec 19, 3:14 am, Erland Sommarskog <esq...@sommarskog.se> wrote:
> (nitin.g...@daffodildb.com) writes:
> > As Nishant said we are not using any special features of Enterprise
> > Edition. Indexed views are not being used and data is taken directly
> > from tables.
>
> > Regarding the execution plan, it may be different due to different
> > sizes of both databases.If you want to compare Standard and Enterprise, you must of course
> use the same database on the same hardware. Else the test is meaningless.
>
> > 1. Enterprise Edition has its own Query running mechanism ( which is
> > different and faster than Standard Edition mechanism) or NOT ?
> > 2. If it is special, what kind of performance differences we will get
> > while using Std Edition.
> > 3. Is there any specific DB size ( or table sizes ) for which Standard
> > Edition is fine and after that one should go for Enterprise.Rather than asking questions on the net, and hope that people will look
> up the answers for you, why not look in this place in Books Online
> instead:
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/81f3e917-884a-4cc8-aca2-0a5fea89f355.htm
>
> --
> Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
>
> Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
> Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
[Back to original message]
|