Ratheesh.K.Nair (11/16/2012)
Thanks Kevin,Ours is a small organization and cant afford consultants at this point.
Hopefully you can afford to have database servers that take hours to return answers to queries. I would be willing to bet there are any number of other suboptimal/unfortunate things in place, such as maintenance practices (LOTS here), integrity checks, server/sqlserver/database settings, ability to recover in an outage, etc. Many of the clients I come across (especially the small ones) truly could not afford to NOT get a person on board for at least a short time to fix critical items. I have also seen many clients spend WAY more on hardware than was necessary because their systems were not properly tuned/maintained.
Anyway - best of luck resolving your performance issues!
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service