Alternative to profiler

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.
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
"Kenny M." <KennyM@.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.
|||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