Performance Issues [message #443044] |
Fri, 12 February 2010 04:24  |
sanyadu
Messages: 30 Registered: October 2006 Location: Chicago
|
Member |
|
|
Hi All,
In DB environment , I have removed all the objects, grants , indexes etc. ( The database have nothing except the schema) and recreated the same from existing scripts. As soon as i did this i got huge performance issues.
Can you please help me what do i need to do get my previous statistics.
Thanks
Sandeep.
|
|
|
|
|
Re: Performance Issues [message #443053 is a reply to message #443051] |
Fri, 12 February 2010 04:56   |
JRowbottom
Messages: 5933 Registered: June 2006 Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
Oh dear.
My first guess would be that the script that you ran did not recreate all the indexes that you had in the application.
Do you have a backup?
|
|
|
Re: Performance Issues [message #443055 is a reply to message #443044] |
Fri, 12 February 2010 05:18   |
sanyadu
Messages: 30 Registered: October 2006 Location: Chicago
|
Member |
|
|
I Used the same scripts which i have in SIT environment. and compared the indexes , they are exactly same. and I don't have issues in SIT environment.
|
|
|
Re: Performance Issues [message #443057 is a reply to message #443044] |
Fri, 12 February 2010 05:26   |
cookiemonster
Messages: 13965 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
What's going slow? everything? certain things? We need some more details here.
If you've got particular statements that are running slow then get an explain plan for it, get an explain plan for the same statement on the db that isn't running slow and compare.
|
|
|
|