[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
[sqr-users] SQL Perfomance monitoring in an SQR
- Subject: [sqr-users] SQL Perfomance monitoring in an SQR
- From: "ashish kothary" <a_kothary@hotmail.com>
- Date: Wed, 02 Aug 2006 16:27:37 +0000
- Bcc:
- Delivery-date: Wed, 02 Aug 2006 12:30:06 -0400
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
Hi All
I have a SQR which all of a sudden is taking a long time to run. Jumped from
20 mins to 2 Hr. This SQR has tons of SQL Statement in them. How do I find
out which SQL is takinga long time to run. I am running this SQR thru PS
Prcoess Schedular. using -S flag gives me some detauils but not the timings.
Database is MS-SQL Server.
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users