May 19, 2003 at 12:54 pm
Hi,
We have BI reports and ETL accessing data from SQL Server 2000, which contains 10 databases. Recently, happened on Tuesday morning at most, our web reports received error message "Failed to acquire more memory blocks".
We are investigating the application side, at the mean time, we want to look at SQL Server side to capture if there's any heavy activities running in server on Tuesday morning. We are suspecting a payroll system running on every Tuesday morning in Payroll database. We have been confirmed that we seldom use 30% of memory in server.
Should I schedule a SQL Server profiler and what kind of Event classes and events should be included in the trace file? Is there any suggestion on our situation?
Thank you in advance.
Edited by - jenniferhu46 on 05/19/2003 1:02:29 PM
May 22, 2003 at 8:00 am
This was removed by the editor as SPAM
June 14, 2003 at 12:10 pm
MS recommend that System monitor is used when checking hardware issues.
June 16, 2003 at 6:55 am
It depends on how the Payroll system accesses the database.
Is it a series of stored procedures? Updates? You should have an idea of what the payroll system does.
I also agree that you should also have the system monitor running. Check for bottlenecks.
Check out this article:
http://www.sql-server-performance.com/sql_server_performance_audit2.asp
Bonne chance
Patrick
Quand on parle du loup, on en voit la queue
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply