[SMS2k3] - SQL Server Tuning

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Geoff Walker (geoffw_at_m-v-t.com)
Date: 04/09/04 

Date: Fri, 9 Apr 2004 11:34:31 -0600

What kind of tuning for SQL Server 2000 helps the performance of SMS2003?

I am starting to notice that status message viewings are taking longer and
longer to load, even on the SMS server itself. 

-- 
--Geoff Walker
  Mesilla Valley Transportation
  http://www.m-v-t.com

Relevant Pages

  • Re: Do UDFs slow down Stored Proc execution?
    ... Tuning the queries of course would be the correct thing to do. ... works beautifully from a business logic perspective. ... I have been plowing through the Microsoft SQL Server 2000 Performance ... I don't know if you actually want to see that proc. ...
    (microsoft.public.sqlserver.programming)
  • Re: Advice on middleware products for TRUE Scaling out of SQL Server
    ... extensive/constant query tuning and add/adjust indexes and regularly ... We also update statistics and defrag the indices (and rebuild the ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • Re: Advice on middleware products for TRUE Scaling out of SQL Server
    ... we had two boxes maxing out and were ready to buy a 3rd ... thing) but it can show how much a difference simple tuning can make. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • RE: Round 2:Database Engine Tuning Advisor suggestion to replace synta
    ... I think that I found the reason. ... "I am a developer in the Database Tuning Advisor team. ... As we can see that the reason is that for sp_executesql, SQL Server could not return an execution plan for tuning, so it ...
    (microsoft.public.sqlserver.tools)
  • Re: Tools similar to Quest SQL Tuning module.
    ... btw.) Symantec and Embarcadero have some performance tuning products, ... "I support PASS - the Professional Association for SQL Server ... and suggestion alternative methods of writing it similar to the Quest ...
    (microsoft.public.sqlserver.tools)