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-02 : 06:02:27
|
| Hi allI need help from you guys,which helps me a lotI have to give perfornce recomandation to the DB which is on offlinewhat are areas i have to check,can some body send check list what i have to lookKindly help meThanks In advanceSreenivasaRaoBangalore,INDIA |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2007-05-02 : 06:57:08
|
| I'm slightly confused....your "DB is offline" and you want to report on it's performance?IF it's offline....it'll have NO performance....it's not accessible!or are you asking for suggestions on how to improve a DB performance during a offline activity ie by adding indicies, etc?Please clarify your current problem and what improvements you are looking to implement or what performance change you are looking for. |
 |
|
|
sponguru_dba
Yak Posting Veteran
93 Posts |
Posted - 2007-05-02 : 07:10:45
|
| Thanks for ReplayClient given scheam(which having tables,view,proc,trigger etc..)by seeing that schema we have to recomand the client do this do that...do'nt do that like that we have recomandbasically off line data means it is working only but is not production server it is test serverthanks in AdvanceSreenivasaRaoBangalore,INDIA |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2007-05-02 : 10:24:24
|
| 1. ensure all tables have primary keys.2. ensure all relevant indices are in place on each table....profiling the code reading from the tables will help identify any SCANS.3. encourage/dump any "CURSORS"4. use the "index tuning" wizard.5. hire somebody experienced in this area....if you're trying to advise a client and you don't know this stuff already....that's a client who's going to walk away!!! |
|
|
|
|
|
|
Performacne recomandation If DB in offline