Tools similar to Quest SQL Tuning module.

30 Jan 2006 4:47 PM

Charlie

Is anyone aware of third party tools that will analyze sql statements/scripts
and suggestion alternative methods of writing it similar to the Quest
product? I've found a few but they are not for MSSQL.

Charlie.

31 Jan 2006 8:16 AM

Michael Cheng [MSFT]

Hi Charlie,

I have searched in google.com and cannot find any third party tools on this
aspect neither. Let's wait to see whether other community could share their
experience here.

Sincerely yours,

Michael Cheng
Microsoft Online Partner Support
======================================================
PLEASE NOTE the newsgroup SECURE CODE and PASSWORD will be updated at 9:00
AM PST, February 14, 2006. Please complete a re-registration process by
entering the secure code mmpng2006 when prompted. Once you have entered the
secure code mmpng2006, you will be able to update your profile and access
the partner newsgroups.
======================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

2 Feb 2006 10:12 PM

Bob

Microsoft support team using google.com? What will mgmt at Redmond say? Tsk
Tsk... (just kidding) :-)

Show quote

"Michael Cheng [MSFT]" wrote:

> Hi Charlie,
>
> I have searched in google.com and cannot find any third party tools on this
> aspect neither. Let's wait to see whether other community could share their
> experience here.
>
>
> Sincerely yours,
>
> Michael Cheng
> Microsoft Online Partner Support
> ======================================================
> PLEASE NOTE the newsgroup SECURE CODE and PASSWORD will be updated at 9:00
> AM PST, February 14, 2006. Please complete a re-registration process by
> entering the secure code mmpng2006 when prompted. Once you have entered the
> secure code mmpng2006, you will be able to update your profile and access
> the partner newsgroups.
> ======================================================
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>

3 Feb 2006 9:23 PM

sqldba

Looks like Microsoft should work on a solution/tool since Quest is the
only player in the game apparently.

Charlie.

Bob wrote:
Show quote

> Microsoft support team using google.com? What will mgmt at Redmond say? Tsk
> Tsk... (just kidding) :-)
>
> "Michael Cheng [MSFT]" wrote:
>
> > Hi Charlie,
> >
> > I have searched in google.com and cannot find any third party tools on this
> > aspect neither. Let's wait to see whether other community could share their
> > experience here.
> >
> >
> > Sincerely yours,
> >
> > Michael Cheng
> > Microsoft Online Partner Support
> > ======================================================
> > PLEASE NOTE the newsgroup SECURE CODE and PASSWORD will be updated at 9:00
> > AM PST, February 14, 2006. Please complete a re-registration process by
> > entering the secure code mmpng2006 when prompted. Once you have entered the
> > secure code mmpng2006, you will be able to update your profile and access
> > the partner newsgroups.
> > ======================================================
> > When responding to posts, please "Reply to Group" via your newsreader so
> > that others may learn and benefit from your issue.
> > =====================================================
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> >

3 Feb 2006 9:24 PM

sqldba

Looks like Microsoft should work on a solution/tool since Quest is the
only player in the market apparently.

Charlie.

Bob wrote:
Show quote

> Microsoft support team using google.com? What will mgmt at Redmond say? Tsk
> Tsk... (just kidding) :-)
>
> "Michael Cheng [MSFT]" wrote:
>
> > Hi Charlie,
> >
> > I have searched in google.com and cannot find any third party tools on this
> > aspect neither. Let's wait to see whether other community could share their
> > experience here.
> >
> >
> > Sincerely yours,
> >
> > Michael Cheng
> > Microsoft Online Partner Support
> > ======================================================
> > PLEASE NOTE the newsgroup SECURE CODE and PASSWORD will be updated at 9:00
> > AM PST, February 14, 2006. Please complete a re-registration process by
> > entering the secure code mmpng2006 when prompted. Once you have entered the
> > secure code mmpng2006, you will be able to update your profile and access
> > the partner newsgroups.
> > ======================================================
> > When responding to posts, please "Reply to Group" via your newsreader so
> > that others may learn and benefit from your issue.
> > =====================================================
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> >

22 Mar 2006 5:47 AM

Kevin Kline [MVP]

Hi Charlie,

Quest's tool is the only one that I'm aware of. (Quest is my employer,
btw.) Symantec and Embarcadero have some performance tuning products, but I
don't think they include tuning recommendations for specific SQL statements
like Quest's SQL Tuning does. Hope this helps,

-Kevin Kline
SQL Server MVP

"I support PASS - the Professional Association for SQL Server
(www.sqlpass.org)"

Show quote

"Charlie" <SQL@newsgroups.nospam> wrote in message
news:4091DDBA-EBEF-4C6D-9445-C2A72D120E50@microsoft.com...
> Is anyone aware of third party tools that will analyze sql
> statements/scripts
> and suggestion alternative methods of writing it similar to the Quest
> product? I've found a few but they are not for MSSQL.
>
> Charlie.
>