Home > Archive > SQL Server Programming > June 2005 > sql
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| what is a workload file and how do i create one?
| |
| Mike Hodgson 2005-06-10, 4:03 am |
| Already answered that in your other post (Jun7 "sql quest").
Cut 'n paste:
In my mind that is a file produced by SQL profiler that can be
applied to the Index Tuning Wizard to provide a sample workload on a
database that the wizard (or it's successor, Database Tuning
Analyzer) can analyze to give you index recommendations.
--
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@mallesons.nospam.com |* W* http://www.mallesons.com
ichor wrote:
>what is a workload file and how do i create one?
>
>
>
>
| |
| Mike Epprecht \(SQL MVP\) 2005-06-10, 4:03 pm |
| And if you don't believe Mike's answer on the 7th, I would give the same
answer.
Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Mike Hodgson" <mike.hodgson@mallesons.nospam.com> wrote in message
news:OdfLqfWbFHA.2968@TK2MSFTNGP10.phx.gbl...
> Already answered that in your other post (Jun7 "sql quest").
> Cut 'n paste:
>
> In my mind that is a file produced by SQL profiler that can be
> applied to the Index Tuning Wizard to provide a sample workload on a
> database that the wizard (or it's successor, Database Tuning
> Analyzer) can analyze to give you index recommendations.
>
> --
> *mike hodgson* |/ database administrator/ | mallesons stephen jaques
> *T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
> *E* mailto:mike.hodgson@mallesons.nospam.com |* W*
> http://www.mallesons.com
>
>
>
> ichor wrote:
>
>
|
|
|
|
|