You can analyze your queries with using SQL Server Profiler and SQL Server Query Analizer. You can determine your slower queries and analyze them which operation causes slow performance.
After analyzing that, if you found a join, that slowers your system, you can try adding index to that foreign key column. That will increase the joined select operation. We have done that in our project before. ~~~~~~~~~~~~~~~~~~~~~~~~ Harun Yiğit Legoz HyundaiAssan - Senior Software Developer http://www.hylegoz.net http://hylegoz.spaces.live.com On Wed, Jun 3, 2009 at 3:17 PM, Anish V S <[email protected]> wrote: > Dear Friends, > > 7 months back i have installed a payroll application in an office.Now it > seems very slow when accessing data from backend. The size of backend about > 8 gb in size. > > How can i make it fast? > > What are the possible reason of slow performance? >
