SQL Server Performance

We optimized our reporting and slowed down our data input!

Discussion in 'SQL Server 2005 General Developer Questions' started by Milano, Jul 24, 2008.

  1. Milano New Member

    We have a SQL Server 2K5 DB Application (with Merge Replication Involved) and we were having performance issues with Reporting (they took too long to generate). We introduced Maintained Views to reduce our reporting times and discovered that most of our data input functions through our front end GUI have ground to a halt. Our front end is Delphi 7 using ADO components to access the DB.
    How can we increase the speed of our reports without compromising speed of data input?
  2. satya Moderator

    Welcome to the forums.
    What is the SQL edition you are using?
    What is the hardware configuraiton, such as RAID, MEMORY etc?
    what is the usage of application & reporting on day to day basis?

Share This Page