Hello,
Is there any exact database size limitation for standard edition? My
database is almost 5 GB and it's getting too slow. Do i have to switch to
enterprise?
Is there any way to check the database to see it's certainly tuned and
optimized and the only problem is the edition of SQL Server I use?
Thanks in advance,
MathewThere is no database size limitation for Standard Edition.
Have you tried running the Database Tuning Advisor and see if you can create
some additional/better indexes to support your larger database? That's
probably the first thing you should try... You might also investigate
looking at some performance counters to determine where your performance
bottlenecks are.
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"Mathew" <Mathew@.discussions.microsoft.com> wrote in message
news:EBA743F5-E065-4857-9976-3B1A37CB4AD2@.microsoft.com...
> Hello,
> Is there any exact database size limitation for standard edition? My
> database is almost 5 GB and it's getting too slow. Do i have to switch to
> enterprise?
> Is there any way to check the database to see it's certainly tuned and
> optimized and the only problem is the edition of SQL Server I use?
> Thanks in advance,
> Mathew|||update the statistics in the database, defrag your indexes (set the fill
ratio to 100%)
Defrag your disk
Identify the bottleneck (CPU, Memory, disk...)
How many disks have you and what is the Raid level?
"Mathew" <Mathew@.discussions.microsoft.com> wrote in message
news:EBA743F5-E065-4857-9976-3B1A37CB4AD2@.microsoft.com...
> Hello,
> Is there any exact database size limitation for standard edition? My
> database is almost 5 GB and it's getting too slow. Do i have to switch to
> enterprise?
> Is there any way to check the database to see it's certainly tuned and
> optimized and the only problem is the edition of SQL Server I use?
> Thanks in advance,
> Mathew|||Hi Mathew,
sql server, like any relational database, should be kept tuned up and
properly indexed.....there are lots and lots of books on the topic.
I don't recommend you try and learn how to tune a database one question
at a time on a newsgroup.
5GB is a small database and unless you are doing something strange you
should see good performance from it.
Peter
www.peternolan.com
Monday, March 26, 2012
Enterprise or Standard edition !
Labels:
database,
edition,
enterprise,
exact,
limitation,
microsoft,
mydatabase,
mysql,
oracle,
server,
size,
slow,
sql,
standard,
switch
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment