http://sqlserver.ro/forums/16/ShowForum.aspxenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlserver.ro/forums/thread/9539.aspxTue, 04 Jun 2013 11:13:56 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:9539xmldeveloper0http://sqlserver.ro/forums/thread/9539.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=9539Ar fi util un baseline daca exista pe vechea configuratie. Altfel este greu de spus ca nu s-a imbunatatit nimic.http://sqlserver.ro/forums/thread/9537.aspxMon, 03 Jun 2013 15:37:53 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:9537Diana0http://sqlserver.ro/forums/thread/9537.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=9537...si, daca ai timp, relateaza-ne cum evolueaza lucrurile.http://sqlserver.ro/forums/thread/9536.aspxMon, 03 Jun 2013 15:27:20 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:9536Diana0http://sqlserver.ro/forums/thread/9536.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=9536Foloseste 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/ <br />Full text poate pune si el probleme.http://sqlserver.ro/forums/thread/9535.aspxMon, 03 Jun 2013 14:00:51 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:9535rsocol0http://sqlserver.ro/forums/thread/9535.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=9535Probabil esti limitat de disc. Incearca sa mai faci ceva tuning la query-urile care dureaza mult, ca sa foloseasca mai bine indecsii. <br /> <br />Razvanhttp://sqlserver.ro/forums/thread/9534.aspxMon, 03 Jun 2013 13:43:38 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:9534Teo0http://sqlserver.ro/forums/thread/9534.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=9534Am sql server 2008 r2 standard pe 64 bit<br>Am schimbat serverul, am pus pe un EqualLogic PS-M4110E cu 4 procesoare&nbsp; Intel Xeon E5-4650 2.70 GHz<br>(8 socket, 64 logice) si 128 G RAM<br>E cam de 4 x ce aveam inainte<br><br>La performanta in sql nu se simte absolut nimic.<br><br>sql vede toate procesoarele, ...<br><br>?<br><br><br>