venkat.saginath (11/17/2008)
If the user complaint you that application is running very slow. Asa DBA where do you start your work ???how do you find where exactly
the problem is???
After logshipping configured,users are connecting secondary
server...how can you disconnect them?
Log file size increasing ,..even after logshipping connfigured??
what could be the reason?
what are the configuration changes before and after installing sql server service pack???
1. check the modules in the application wher ethe problem is.
2. check the asssociated tables with that module.
3. start to work on those tables.
4. first try to optimize the queries. and if the same problem persists thne do any heavy tasks
kshitij kumar
kshitij@krayknot.com
www.krayknot.com