[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Re: [sqr-users] SQL Perfomance monitoring in an SQR
- Subject: Re: [sqr-users] SQL Perfomance monitoring in an SQR
- From: "Robert Goshko" <robert.goshko@gmail.com>
- Date: Wed, 2 Aug 2006 11:43:29 -0600
- Delivery-date: Wed, 02 Aug 2006 13:45:27 -0400
- Domainkey-signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;b=XxyTVhgtl9/whuYYn8IxHNCQntcrmgSSMExoDTDseuQrsVAnHebvONKu1ZqKNvz3pOz13NCu9wvBYKe8ZlEehtojyOQlYSuSQZT0TliQJGtDu1m4lPw7870Q2QWD1pvBSRuCeqRB6hZWQMp/mEN8A89s7ov0V9bLckqwP8OVxEw=
- In-reply-to: <BAY106-F25155D7CF86058A8D21F7583520@phx.gbl>
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
- References: <BAY106-F25155D7CF86058A8D21F7583520@phx.gbl>
On 8/2/06, ashish kothary <a_kothary@hotmail.com> wrote:
> 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.
Quickest way is to put some show statements in your program, 1 before
each "begin-select' and then one inside with a time stamp, then you
can see which is taking the longest to run.
Your DBA may be able to tell you which SQL is hitting the database and
causing issues.
--
...Rob
-- No trees were killed in the sending of this message. However a
large number of electrons were terribly inconvenienced.
================================================
Robert Goshko
Registered Linux User #260513
Want a Gmail account, 2.6+ GB web mail (for free), just ask me.
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users