SQL Server Performance Forum – Threads Archive

Database/Server Performance

Is there any way to perform some form of benchmark on the database/server performance during certain hours? We have noticed a tremendous lag in database response (particularly in the mornings) and at times have trouble logging in, searching, saving, and printing. My assumption is that either the server is busy due to the number of users at certain times or the database code is becoming overwhelmed with the volume of information added daily. It may become an issue when we increase the availability of the database.

I don’t think you need any benchmark.
SQL has tools to find out performance, like: Performance Monitor and Profiler. Also a lot of articles ib our forum. One you have to read: http://www.sql-server-performance.com/sql_server_performance_audit11.asp
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided â€œAS ISâ€ with no warranties for accuracy.

http://www.sql-server-performance.com/sql_server_performance_audit.asp is the good candidate for you to tackle the issues you’re having currently. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>