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 |
|
sponguru_dba
Yak Posting Veteran
93 Posts |
 Posted - 2007-05-23 : 02:38:47
|
| HiI have a back of custurmer Database,my task i have to restore that Database,and i have to do high level analysis,and i have to give some recommenadation.some body help...what i have to do in higher level analysis to get performace of DatabaseThanks in AdvacneSreenivasaRaoBangalore,INDIA |
|
|
deepakontheweb
Starting Member
14 Posts |
Posted - 2007-05-23 : 06:12:08
|
| Check for the following:1. Database Design2. Table structure and data type usage3. Optimize Stored procedure, views, funcations and trigger code4. Make a test case scenario for all report based stored procedures.5. Ask client for a list of time-consuming queries and their daily bottleneck areas in application/database.6. Run a test/development application on the database and figure out gray area adn optimize the sql object code and finetune it using sql profiler/execution plan perfmon utility.If this is a high level analysis you mean for.. Have a nice time !! CheersDeepak KumarSQL Server MVP, MCDBAdeepak.kumar@sqlknowledge.com |
 |
|
|
sponguru_dba
Yak Posting Veteran
93 Posts |
Posted - 2007-05-24 : 03:56:54
|
| Hi DeepakThanks for AdvaiceBut client is not willing to give Application,he given only backup,by restoring that i have to analysis and i have to give recommendationsThanks in AdvanceSreenivasaRaoBangalore,INDIA |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-24 : 10:08:24
|
| Hard to do without knowledge of business requirement. |
|
|
|
|
|
|
What is higher level analysis of static Database?