Welcome to Sign in | Help
in Search

Alt server, ac performanta.

Last post 06-04-2013, 2:13 PM by xmldeveloper. 4 replies.
Sort Posts: Previous Next
  •  06-03-2013, 4:43 PM 9534

    Alt server, ac performanta.

    Am sql server 2008 r2 standard pe 64 bit
    Am schimbat serverul, am pus pe un EqualLogic PS-M4110E cu 4 procesoare  Intel Xeon E5-4650 2.70 GHz
    (8 socket, 64 logice) si 128 G RAM
    E cam de 4 x ce aveam inainte

    La performanta in sql nu se simte absolut nimic.

    sql vede toate procesoarele, ...

    ?


  •  06-03-2013, 5:00 PM 9535 in reply to 9534

    Re: Alt server, ac performanta.

    Probabil esti limitat de disc. Incearca sa mai faci ceva tuning la query-urile care dureaza mult, ca sa foloseasca mai bine indecsii.

    Razvan
  •  06-03-2013, 6:27 PM 9536 in reply to 9535

    Re: Alt server, ac performanta.

    Foloseste scriptul lui Paul Randal (http://www.sqlskills.com/blogs/paul/wait-statistics-or-please-tell-me-where-it-hurts/) ca sa te lamuresti de unde sa incepi si sp_whoisactive (http://sqlblog.com/blogs/adam_machanic/archive/2012/03/22/released-who-is-active-v11-11.aspx) ca sa identifici eventualele query-uri cu probleme. Glenn Berry ofera cateva scripturi care iti pot fi de folos: http://sqlserverperformance.wordpress.com/2013/05/06/sql-server-2008-r2-diagnostic-information-queries-may-2013/
    Full text poate pune si el probleme.
  •  06-03-2013, 6:37 PM 9537 in reply to 9534

    Re: Alt server, ac performanta.

    ...si, daca ai timp, relateaza-ne cum evolueaza lucrurile.
  •  06-04-2013, 2:13 PM 9539 in reply to 9534

    Re: Alt server, ac performanta.

    Ar fi util un baseline daca exista pe vechea configuratie. Altfel este greu de spus ca nu s-a imbunatatit nimic.
    Cristian Andrei Lefter, SQL Server MVP
    MCT, MCSA, MCDBA, MCAD, MCSD .NET,
    MCTS, MCITP - Database Administrator SQL Server 2005
    http://sqlserver.ro
View as RSS news feed in XML
Powered by Community Server (Commercial Edition), by Telligent Systems