Friday, March 30, 2012
Query Profiler Event log software
Thanks
Marksp_cycle_errorlog|||sp_cycle_errorlog will only cycle the SQL Server error log which is not what the original poster requested.
You MIGHT be able to send the profiler results to a table in the database and then have some other process running periodically (every 1/2 hour) come in and delete from that table where the records are more than X minutes old.
This could potentially get quite ugly, however, and it is not something I would personally recommend. Have you looked at some 3rd part performance monitoring software? You can also use NT performance alerts and logs to track some (not all) SQL performance points.
Regards,
hmscott|||Thanks for the help. Do you have any suggestions of 4rd party software?|||Thanks for the help. Do you have any suggestions of *3rd* party software? Sorry about that.|||Not sure if it violates the rules of this non-commercial forum. But here goes (apologies in advance to those who get offended):
I have used Spotlight on SQL (was very pleased with the graphical layout and ability to interact and correct problems). Download an evaluation copy at www.quest.com.
Embarcadero has several tools which I have seen demonstrated, but never actually used myself. www.embarcadero.com
I have also recently downloaded Microsoft's SQL Best Practices Analyzer tool and used it to analyze my installations. This is not a performance analyzer per se, but it may help you to highlight problem areas and/or inefficient designs.
Best of luck,
hmscott
Tuesday, March 20, 2012
Query Parameter problem
I have created 2 datasets. my first dataset quary parameter is BU. query is like following.
WITH
MEMBER [Measures].[Amount] AS 'IIF(ISEMPTY([Measures].[Amount Usd]),0,[Measures].[Amount Usd])'
MEMBER [Measures].[Description] AS '[Ledger—AccountCode].CurrentMember.Name'
SET [FilteredBUList] AS strtoset(@.BU)
SELECT
{[Measures].[Description],[Measures].[Amount]} ON COLUMNS,
[FilteredBUList] on rows
FROM Profitability
my second dataset query is like following,
SET [FilteredBUList] AS strtoset(@.BU)
SET [customtimeset] AS.....
SELECT
{[Measures].[Description],[Measures].[Amount]} ON COLUMNS,
intersect( [FilteredBUList],...) on rows
FROM Profitability
i need to map previous query BU parameter to the second dataset parameter. pls tel m the proper way.
cant access report parameter in this way from different dataset.
WITH
MEMBER [Measures].[Amount] AS 'IIF(ISEMPTY([Measures].[Amount Usd]),0,[Measures].[Amount Usd])'
MEMBER [Measures].[Description] AS '[Ledger—AccountCode].CurrentMember.Name'
SET [FilteredBUList] AS strtotuple(@.BU)
SELECT
{[Measures].[Description],[Measures].[Amount]} ON COLUMNS,
[FilteredBUList] on rows
FROM Profitability