Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kond.mohan
Posting Yak Master
213 Posts |
 Posted - 2011-10-22 : 03:14:58
|
| Hii am working on huge database(more than 300GB) My client want expect betterperformace through all database operations .1 indexes created on database properly 2 queries done by efficient maner3 existing database structurd is good..how to maiatain database more efficiently & effectively in sql server 2008 mohan |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-22 : 04:35:19
|
| 1. for creating indexes run database tuning wizard and as per recommendation analyse queries and find out which indexes added will result in good performance boost. specifically look for queries run very frequently and taking large amount of time to get executed.2.analyse query execution plan and see how you can fine tune them by analysing costly steps3.this would require some amount of effort as it might end up in quite a lot of redesigning. Always think in terms of implemetation like which of recommendation can be implemented and maintained with minmum of effort. To start with,see if tables are normalised if yes to what level etc------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-10-22 : 06:54:28
|
| [url]http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/[/url][url]http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/[/url]--Gail ShawSQL Server MVP |
|
|
|
|
|
|
Improve database perfomance