Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Usage-based optimization based on QueryLog File? Expand / Collapse
Author
Message
Posted Friday, July 16, 2010 2:32 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, May 30, 2012 3:54 AM
Points: 13, Visits: 72
Hi,

the usage-based aggregation optimization wizard does not seem to offer a way to configure the source of the log it uses for optimization. I am using QueryLog and I have configured it to write to a file instead of a log table. I have done this simply because there is no database in our project where I could write the data to, and I have access to a share on the server where I store the file.

Anyway, does anyone know how to tell the aggregation wizard to read the query information from this file? Also, in general, where does the wizard get the information about the connection string from if I used a log table?

Any help is very much apprecitated!

Nicolas
Post #953673
Posted Friday, July 16, 2010 2:48 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 12:48 AM
Points: 40,193, Visits: 36,598
Analysis services? Are you designing cube optimisations?


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #953692
Posted Friday, July 16, 2010 2:50 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, May 30, 2012 3:54 AM
Points: 13, Visits: 72
Sorry, yes, I am using Analysis Services 2005 and Visual Studio 2005. I want to design cube aggregations with the usage-based optimization wizard.
Post #953693
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse