Home All Groups Group Topic Archive Search About

install Performance Tools

Author
9 Nov 2006 10:24 AM
SteelMillDon
Hi,
I have looked for some time now and I cannot see how to install the
Performance Tools in a pre installed SQL Server 20005. How do I go about this?

Author
9 Nov 2006 10:52 AM
Hilary Cotter
I am unaware of Microsoft Provided Performance tools. Are you by chance
talking about performance monitor? You can launch this via perfmon from the
command line. The DMV's also provide important performance counters.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



Show quote
"SteelMillDon" <SteelMillDon@noemail.noemail> wrote in message
news:2131CACB-066A-40F5-A95E-B3EAFE509DB5@microsoft.com...
> Hi,
> I have looked for some time now and I cannot see how to install the
> Performance Tools in a pre installed SQL Server 20005. How do I go about
> this?
Author
9 Nov 2006 11:00 AM
SteelMillDon
Hi,
No. SQL Server has these tool. I belive it is what edition I have. I need
the standard not the workgroup.

Thanks

Show quote
"Hilary Cotter" wrote:

> I am unaware of Microsoft Provided Performance tools. Are you by chance
> talking about performance monitor? You can launch this via perfmon from the
> command line. The DMV's also provide important performance counters.
>
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
>
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
>
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
>
>
> "SteelMillDon" <SteelMillDon@noemail.noemail> wrote in message
> news:2131CACB-066A-40F5-A95E-B3EAFE509DB5@microsoft.com...
> > Hi,
> > I have looked for some time now and I cannot see how to install the
> > Performance Tools in a pre installed SQL Server 20005. How do I go about
> > this?
>
>
>
Author
9 Nov 2006 12:56 PM
SteelMillDon
Hi,
I have upgraded from workgroup to standard and still I cannot find how to
add the sql performanve tools. We have one system that hase the tools on it
that was configured from the start but we cannot seem to add the tools if
they where not installed from the start. Please help.

Thanks

Show quote
"SteelMillDon" wrote:

> Hi,
> I have looked for some time now and I cannot see how to install the
> Performance Tools in a pre installed SQL Server 20005. How do I go about this?
Author
9 Nov 2006 11:05 PM
Technosapien
Do you have access to the SQL install media? If so, try running Setup again.
Sorry I can't be specific, I don't know 2005, but at some point during the
install, you should be offered the opportunity to install missing compnents,
such as Performance Tools.
--
Technosapien


Show quote
"SteelMillDon" wrote:

> Hi,
> I have upgraded from workgroup to standard and still I cannot find how to
> add the sql performanve tools. We have one system that hase the tools on it
> that was configured from the start but we cannot seem to add the tools if
> they where not installed from the start. Please help.
>
> Thanks
>
> "SteelMillDon" wrote:
>
> > Hi,
> > I have looked for some time now and I cannot see how to install the
> > Performance Tools in a pre installed SQL Server 20005. How do I go about this?
Author
10 Nov 2006 11:34 AM
SteelMillDon
I have tried this but cannot find where this option is.   I'm tryin to get
help from microsoft with my msdn support.

Show quote
"Technosapien" wrote:

> Do you have access to the SQL install media? If so, try running Setup again.
> Sorry I can't be specific, I don't know 2005, but at some point during the
> install, you should be offered the opportunity to install missing compnents,
> such as Performance Tools.
> --
> Technosapien
>
>
> "SteelMillDon" wrote:
>
> > Hi,
> > I have upgraded from workgroup to standard and still I cannot find how to
> > add the sql performanve tools. We have one system that hase the tools on it
> > that was configured from the start but we cannot seem to add the tools if
> > they where not installed from the start. Please help.
> >
> > Thanks
> >
> > "SteelMillDon" wrote:
> >
> > > Hi,
> > > I have looked for some time now and I cannot see how to install the
> > > Performance Tools in a pre installed SQL Server 20005. How do I go about this?
Author
17 Nov 2006 2:06 AM
Paul A. Mestemaker II [MSFT]
Are you looking for SQL Server Profiler and Database Engine Tuning Advisor?

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

Show quote
"SteelMillDon" <SteelMillDon@noemail.noemail> wrote in message
news:C5534832-C3E4-48ED-AABC-3F20E8C5116C@microsoft.com...
>I have tried this but cannot find where this option is.   I'm tryin to get
> help from microsoft with my msdn support.
>
> "Technosapien" wrote:
>
>> Do you have access to the SQL install media? If so, try running Setup
>> again.
>> Sorry I can't be specific, I don't know 2005, but at some point during
>> the
>> install, you should be offered the opportunity to install missing
>> compnents,
>> such as Performance Tools.
>> --
>> Technosapien
>>
>>
>> "SteelMillDon" wrote:
>>
>> > Hi,
>> > I have upgraded from workgroup to standard and still I cannot find how
>> > to
>> > add the sql performanve tools. We have one system that hase the tools
>> > on it
>> > that was configured from the start but we cannot seem to add the tools
>> > if
>> > they where not installed from the start. Please help.
>> >
>> > Thanks
>> >
>> > "SteelMillDon" wrote:
>> >
>> > > Hi,
>> > > I have looked for some time now and I cannot see how to install the
>> > > Performance Tools in a pre installed SQL Server 20005. How do I go
>> > > about this?
Author
17 Nov 2006 10:23 AM
SteelMillDon
Yes

Show quote
"Paul A. Mestemaker II [MSFT]" wrote:

> Are you looking for SQL Server Profiler and Database Engine Tuning Advisor?
>
> Paul A. Mestemaker II
> Program Manager
> Microsoft SQL Server Manageability
> http://blogs.msdn.com/sqlrem/
>
> "SteelMillDon" <SteelMillDon@noemail.noemail> wrote in message
> news:C5534832-C3E4-48ED-AABC-3F20E8C5116C@microsoft.com...
> >I have tried this but cannot find where this option is.   I'm tryin to get
> > help from microsoft with my msdn support.
> >
> > "Technosapien" wrote:
> >
> >> Do you have access to the SQL install media? If so, try running Setup
> >> again.
> >> Sorry I can't be specific, I don't know 2005, but at some point during
> >> the
> >> install, you should be offered the opportunity to install missing
> >> compnents,
> >> such as Performance Tools.
> >> --
> >> Technosapien
> >>
> >>
> >> "SteelMillDon" wrote:
> >>
> >> > Hi,
> >> > I have upgraded from workgroup to standard and still I cannot find how
> >> > to
> >> > add the sql performanve tools. We have one system that hase the tools
> >> > on it
> >> > that was configured from the start but we cannot seem to add the tools
> >> > if
> >> > they where not installed from the start. Please help.
> >> >
> >> > Thanks
> >> >
> >> > "SteelMillDon" wrote:
> >> >
> >> > > Hi,
> >> > > I have looked for some time now and I cannot see how to install the
> >> > > Performance Tools in a pre installed SQL Server 20005. How do I go
> >> > > about this?
>
>
>
Author
22 Nov 2006 7:47 AM
Paul A. Mestemaker II [MSFT]
What SKU of SQL Server are you using? (Express Edition, Workgroup Edition,
Standard Edition, Enterprise Edition, or Developer Edition).  I believe
these performance tools are only included in Standard, Enterprise, and
Developer.  They should be installed if you check the "Workstation
Components" in setup.

Feature Comparison Matrix:
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

With a default installation of the workstation components, you can start
Profiler by running "Profiler90" from the run menu.

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

Show quote
"SteelMillDon" <SteelMillDon@noemail.noemail> wrote in message
news:89E6CBD9-FC09-4D3D-B3CB-A1A26EED57F7@microsoft.com...
> Yes
>
> "Paul A. Mestemaker II [MSFT]" wrote:
>
>> Are you looking for SQL Server Profiler and Database Engine Tuning
>> Advisor?
>>
>> Paul A. Mestemaker II
>> Program Manager
>> Microsoft SQL Server Manageability
>> http://blogs.msdn.com/sqlrem/
>>
>> "SteelMillDon" <SteelMillDon@noemail.noemail> wrote in message
>> news:C5534832-C3E4-48ED-AABC-3F20E8C5116C@microsoft.com...
>> >I have tried this but cannot find where this option is.   I'm tryin to
>> >get
>> > help from microsoft with my msdn support.
>> >
>> > "Technosapien" wrote:
>> >
>> >> Do you have access to the SQL install media? If so, try running Setup
>> >> again.
>> >> Sorry I can't be specific, I don't know 2005, but at some point during
>> >> the
>> >> install, you should be offered the opportunity to install missing
>> >> compnents,
>> >> such as Performance Tools.
>> >> --
>> >> Technosapien
>> >>
>> >>
>> >> "SteelMillDon" wrote:
>> >>
>> >> > Hi,
>> >> > I have upgraded from workgroup to standard and still I cannot find
>> >> > how
>> >> > to
>> >> > add the sql performanve tools. We have one system that hase the
>> >> > tools
>> >> > on it
>> >> > that was configured from the start but we cannot seem to add the
>> >> > tools
>> >> > if
>> >> > they where not installed from the start. Please help.
>> >> >
>> >> > Thanks
>> >> >
>> >> > "SteelMillDon" wrote:
>> >> >
>> >> > > Hi,
>> >> > > I have looked for some time now and I cannot see how to install
>> >> > > the
>> >> > > Performance Tools in a pre installed SQL Server 20005. How do I go
>> >> > > about this?
>>
>>
>>
Author
22 Nov 2006 9:33 AM
SteelMillDon
Standard. Read my past posts for more details

Show quote
"Paul A. Mestemaker II [MSFT]" wrote:

> What SKU of SQL Server are you using? (Express Edition, Workgroup Edition,
> Standard Edition, Enterprise Edition, or Developer Edition).  I believe
> these performance tools are only included in Standard, Enterprise, and
> Developer.  They should be installed if you check the "Workstation
> Components" in setup.
>
> Feature Comparison Matrix:
> http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
>
> With a default installation of the workstation components, you can start
> Profiler by running "Profiler90" from the run menu.
>
> Paul A. Mestemaker II
> Program Manager
> Microsoft SQL Server Manageability
> http://blogs.msdn.com/sqlrem/
>
> "SteelMillDon" <SteelMillDon@noemail.noemail> wrote in message
> news:89E6CBD9-FC09-4D3D-B3CB-A1A26EED57F7@microsoft.com...
> > Yes
> >
> > "Paul A. Mestemaker II [MSFT]" wrote:
> >
> >> Are you looking for SQL Server Profiler and Database Engine Tuning
> >> Advisor?
> >>
> >> Paul A. Mestemaker II
> >> Program Manager
> >> Microsoft SQL Server Manageability
> >> http://blogs.msdn.com/sqlrem/
> >>
> >> "SteelMillDon" <SteelMillDon@noemail.noemail> wrote in message
> >> news:C5534832-C3E4-48ED-AABC-3F20E8C5116C@microsoft.com...
> >> >I have tried this but cannot find where this option is.   I'm tryin to
> >> >get
> >> > help from microsoft with my msdn support.
> >> >
> >> > "Technosapien" wrote:
> >> >
> >> >> Do you have access to the SQL install media? If so, try running Setup
> >> >> again.
> >> >> Sorry I can't be specific, I don't know 2005, but at some point during
> >> >> the
> >> >> install, you should be offered the opportunity to install missing
> >> >> compnents,
> >> >> such as Performance Tools.
> >> >> --
> >> >> Technosapien
> >> >>
> >> >>
> >> >> "SteelMillDon" wrote:
> >> >>
> >> >> > Hi,
> >> >> > I have upgraded from workgroup to standard and still I cannot find
> >> >> > how
> >> >> > to
> >> >> > add the sql performanve tools. We have one system that hase the
> >> >> > tools
> >> >> > on it
> >> >> > that was configured from the start but we cannot seem to add the
> >> >> > tools
> >> >> > if
> >> >> > they where not installed from the start. Please help.
> >> >> >
> >> >> > Thanks
> >> >> >
> >> >> > "SteelMillDon" wrote:
> >> >> >
> >> >> > > Hi,
> >> >> > > I have looked for some time now and I cannot see how to install
> >> >> > > the
> >> >> > > Performance Tools in a pre installed SQL Server 20005. How do I go
> >> >> > > about this?
> >>
> >>
> >>
>
>
>

AddThis Social Bookmark Button