Im currently looking into performance issues around a client that reports against a SQL database. Im not a DBA and my knowledge of SQL is basic. I have been running some perfmon counters against the SQL server whilst running reports. I have installed the reporting client directly on the SQL server.
I have statistics but not entirely sure what they are telling me. I have no benchmark, but i can see definite peaks when the report is running.
Any assistance appreciated.