Hi Experts,
I'm trying to query data from a database of size 10GB. But it is taking too much time to get the data.
I'm uing SQL Server 2005, Xeon 4 processor Server.
The database sits on a single machine.
I don't have clear Idea about scaling.
Is it need to scale-out My database.>>>?
Please could you provide more information to help track down the problem? It will be difficult to track down the cause of the poor performance you are seeing without more information.
It would be useful if you could provide the definitions of your tables and indexes, examples of poor-performing queries and sample data. Also, an indication of the number of rows in your tables would be helpful.
Chris
|||You need to give us some more details so we can give you some useful answers. More details about the hardware, about what symptoms you are seeing, what type of workload that you have, etc.
If you read my blog post (below), it shows some easy steps for gathering some basic information about your hardware and your environment, that will serve as a starting point.
http://glennberrysqlperformance.spaces.live.com/blog/cns!45041418ECCAA960!424.entry
|||Thanks for the reply
More details means,
I need to maintain data of around 500 tables. some tables will have 500000 records,
Maintaining data of an enterprise , like Customers,orders,warehouse etc.
How to maintain such type of database? Any Idea plz?
No comments:
Post a Comment