http://sqlserver.ro/forums/14/ShowForum.aspxenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlserver.ro/forums/thread/4467.aspxSat, 22 Mar 2008 16:54:14 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:4467crestinul0http://sqlserver.ro/forums/thread/4467.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=14&PostID=4467Poti sa folosessti si countertele din performance monitor pt physical reads and logs ss-ti faci o idee de ce s-a intamplat pe serverul sqlhttp://sqlserver.ro/forums/thread/4421.aspxWed, 19 Mar 2008 13:09:25 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:4421B_gd_n[ ]Sahlean0http://sqlserver.ro/forums/thread/4421.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=14&PostID=4421Daca vorbim de SQL2005 atunci aveti DMV:<br><a href="http://msdn2.microsoft.com/en-us/library/ms189741.aspx">sys.dm_exec_query_stats</a><br><a href="http://weblogs.sqlteam.com/mladenp/archive/2006/09/21/12378.aspx">[2]</a><br><a href="http://blogs.msdn.com/saponsqlserver/archive/2007/06/05/sap-dbacockpit-and-some-related-sql-scripts-part-1.aspx">[3]</a><br>http://sqlserver.ro/forums/thread/4420.aspxWed, 19 Mar 2008 10:51:24 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:4420Diana0http://sqlserver.ro/forums/thread/4420.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=14&PostID=4420Incearca <FONT color=#000000 size=2>SET STATISTICS IO ON / OFF - vezi BOL pentru detalii. Obtii informatii utile si din "execution plan" si din optiunile de tipul "showplan set".</FONT>http://sqlserver.ro/forums/thread/4419.aspxWed, 19 Mar 2008 10:31:52 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:4419catalin_gc0http://sqlserver.ro/forums/thread/4419.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=14&PostID=4419<P>Salut,</P> <P>Cum pot sa vad numarul de&nbsp;<FONT size=2>physical reads </FONT><FONT color=#808080 size=2>,</FONT><FONT size=2>logical reads </FONT><FONT color=#808080 size=2>,</FONT><FONT size=2>logical writes si physical writes in urma executarii unui query in SQL 2005? SQL profiler arata Reads si Writes dar nu stiu ce fel de citiri si scrieri sunt.</P></FONT> <P>&nbsp;</P>