http://sqlserver.ro/forums/16/ShowForum.aspxenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlserver.ro/forums/thread/7025.aspxSun, 05 Apr 2009 08:24:46 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:7025marcel soare0http://sqlserver.ro/forums/thread/7025.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=7025nu administrez in mod constant servere de sql, insa probabil zilnic m-as uita in activity monitor, sa vad procesele (detaliat) si task-urile care utilizeaza din plin serverul. in acest fel vad cum sunt uitlizate resursele si apoi as trece la optimizare, vizualizare indecsi etc<br>http://sqlserver.ro/forums/thread/7009.aspxThu, 02 Apr 2009 11:36:48 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:7009ignatandrei0http://sqlserver.ro/forums/thread/7009.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=7009altcineva ? ;-)<br>http://sqlserver.ro/forums/thread/7003.aspxWed, 01 Apr 2009 13:22:41 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:7003neo0http://sqlserver.ro/forums/thread/7003.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=7003<P>eu personal monitorizez:</P> <P>-replicarea;</P> <P>-spatiul, implicit si indecsii =&gt; mentenanta indecsi / statistici</P> <P>-shrink-uri periodice</P>http://sqlserver.ro/forums/thread/7002.aspxWed, 01 Apr 2009 12:50:09 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:7002ignatandrei0http://sqlserver.ro/forums/thread/7002.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=7002Pentru cei care administrati Sql Servere - la ce va uitati regulat ( sa zicem, in fiecare zi / saptamina / luna /an) ? <br>De ex, monitorizati :<br>spatiul liber pe hard<br>fragmentarea indecsilor<br>statusul job-urilor<br><br>Nu ma intereseaza dpdv teoretic ( pentru ca nu am mai termina , probabil) ci dpdv practic ce faceti...<br><br>Multumesc,<br>