Alternative to profiler

23 Nov 2005 1:16 AM

Kenny M.

I can use the Profiler because my DB is on a Hosting, what alternative do I
have to monitor and make tuning to my DB

thks

--
Kenny M.

23 Nov 2005 3:02 PM

Andrew J. Kelly

Do you have sa rights on the SQL Server? If so you might want to try using
Trace instead of profiler.

http://support.microsoft.com/?id=283790

--
Andrew J. Kelly SQL MVP

Show quote

"Kenny M." <Ken***@discussions.microsoft.com> wrote in message
news:D1004DB0-CE29-4CC5-9311-F94E47BB09F3@microsoft.com...
>I can use the Profiler because my DB is on a Hosting, what alternative do I
> have to monitor and make tuning to my DB
>
> thks
> --
> Kenny M.

23 Nov 2005 5:51 PM

David Gugick

Kenny M. wrote:

> I can use the Profiler because my DB is on a Hosting, what
> alternative do I have to monitor and make tuning to my DB
>
> thks

You can start with tuning your existing queries using Query Analyzer or
any query tool and examining the execution plans. With QA, you can use
the Show Execution Plan option. From other tools you can use the SET
STATISTICS PROFILE ON / OFF.

--
David Gugick
Quest Software
www.imceda.com
www.quest.com