Wednesday, March 28, 2012

install Performance Tools

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?
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?
|||Hi,
No. SQL Server has these tool. I belive it is what edition I have. I need
the standard not the workgroup.
Thanks
"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 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?
|||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:
[vbcol=seagreen]
> 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:
|||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:
[vbcol=seagreen]
> 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:
|||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...[vbcol=seagreen]
>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:
|||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...
>
>
|||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...[vbcol=seagreen]
> Yes
> "Paul A. Mestemaker II [MSFT]" wrote:
|||Standard. Read my past posts for more details
"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...
>
>
sql

No comments:

Post a Comment