performance issue - sql server
Posted on 2010-01-01
After shrinking primary and secondary datafiles (coz of disk space issue), i am facing performance issue. I have shrinked data files 20 days back....after this i am facing lot of performance issue like to generate reports it was taking long time, procedure execution is taking long time and simple select query is also taking so long time.
1. please let me know what could be the reason?
2. shall i rebuild/recreate secondary file (partition table) index?....is there any changes in performance after doing this activity?
Note : it is an production server.