Forwarded from NikAmooz | نیک آموز
DeveloperExperienceNanoServer_mid.mp4
7.2 MB
Forwarded from NikAmooz | نیک آموز
#SQLServer
#DMV
#PerformanceTuning
سلام دوستان
در SQL Server یک DMV به نام sys.dm_exec_procedure_stats وجود دارد که در مورد Stored Procedure ها و Execution Plan های کش شده مربوط به آن اطلاعات مفیدی مانند تعداد دفعات اجرا، مدت زمان اجر، تعداد عملیات Read، تعداد عملیات Write و... ارائه می دهد. توجه داشته باشید که این آمار مربوط به Stored Procedureها می باشد.
کوئری زیر را بر روی بانک اطلاعاتی خود اجرا کنید و به خروجی تولید شده آن توجه داشته باشید.
USE YourDB
GO
SELECT TOP 50
s.name + '.' + p.name AS [Procedure]
,qp.query_plan AS [Plan]
,(ps.total_logical_reads + ps.total_logical_writes) /
ps.execution_count AS [Avg IO]
,ps.execution_count AS [Exec Cnt]
,ps.cached_time AS [Cached]
,ps.last_execution_time AS [Last Exec Time]
,ps.total_logical_reads AS [Total Reads]
,ps.last_logical_reads AS [Last Reads]
,ps.total_logical_writes AS [Total Writes]
,ps.last_logical_writes AS [Last Writes]
,ps.total_worker_time AS [Total Worker Time]
,ps.last_worker_time AS [Last Worker Time]
,ps.total_elapsed_time AS [Total Elapsed Time]
,ps.last_elapsed_time AS [Last Elapsed Time]
FROM
sys.procedures AS p WITH (NOLOCK) join sys.schemas s WITH (NOLOCK) ON
p.schema_id = s.schema_id
INNER JOIN sys.dm_exec_procedure_stats AS ps WITH (NOLOCK) ON
p.object_id = ps.object_id
OUTER APPLY sys.dm_exec_query_plan(ps.plan_handle) qp
ORDER BY
[Avg IO] DESC
OPTION (RECOMPILE)
GO
#DMV
#PerformanceTuning
سلام دوستان
در SQL Server یک DMV به نام sys.dm_exec_procedure_stats وجود دارد که در مورد Stored Procedure ها و Execution Plan های کش شده مربوط به آن اطلاعات مفیدی مانند تعداد دفعات اجرا، مدت زمان اجر، تعداد عملیات Read، تعداد عملیات Write و... ارائه می دهد. توجه داشته باشید که این آمار مربوط به Stored Procedureها می باشد.
کوئری زیر را بر روی بانک اطلاعاتی خود اجرا کنید و به خروجی تولید شده آن توجه داشته باشید.
USE YourDB
GO
SELECT TOP 50
s.name + '.' + p.name AS [Procedure]
,qp.query_plan AS [Plan]
,(ps.total_logical_reads + ps.total_logical_writes) /
ps.execution_count AS [Avg IO]
,ps.execution_count AS [Exec Cnt]
,ps.cached_time AS [Cached]
,ps.last_execution_time AS [Last Exec Time]
,ps.total_logical_reads AS [Total Reads]
,ps.last_logical_reads AS [Last Reads]
,ps.total_logical_writes AS [Total Writes]
,ps.last_logical_writes AS [Last Writes]
,ps.total_worker_time AS [Total Worker Time]
,ps.last_worker_time AS [Last Worker Time]
,ps.total_elapsed_time AS [Total Elapsed Time]
,ps.last_elapsed_time AS [Last Elapsed Time]
FROM
sys.procedures AS p WITH (NOLOCK) join sys.schemas s WITH (NOLOCK) ON
p.schema_id = s.schema_id
INNER JOIN sys.dm_exec_procedure_stats AS ps WITH (NOLOCK) ON
p.object_id = ps.object_id
OUTER APPLY sys.dm_exec_query_plan(ps.plan_handle) qp
ORDER BY
[Avg IO] DESC
OPTION (RECOMPILE)
GO
Java 9 new ultimate features SlideShare, Timeline info:
2015-12-10: Feature Complete
2016-02-04: All Tests Run
2016-02-25: Rampdown Start
2016-04-21: Zero Bug Bounce
2016-06-16: Rampdown Phase 2
2016-07-21: Final Release Candidate
2016-09-22: General Availability
#Programming
#Java
by @D4NTESPARDA
2015-12-10: Feature Complete
2016-02-04: All Tests Run
2016-02-25: Rampdown Start
2016-04-21: Zero Bug Bounce
2016-06-16: Rampdown Phase 2
2016-07-21: Final Release Candidate
2016-09-22: General Availability
#Programming
#Java
by @D4NTESPARDA
Mark your calendar: Java 9 finally has a release date
https://www.networkworld.com/article/2920183/microsoft-subnet/mark-your-calendar-java-9-finally-has-a-release-date.html
#WroteBy <Andy Patrizio>
#Date <May 7, 2015 12:35 PM>
#Programming
#Java
by @D4NTESPARDA
https://www.networkworld.com/article/2920183/microsoft-subnet/mark-your-calendar-java-9-finally-has-a-release-date.html
#WroteBy <Andy Patrizio>
#Date <May 7, 2015 12:35 PM>
#Programming
#Java
by @D4NTESPARDA
Network World
Mark your calendar: Java 9 finally has a release date
Oracle's long-running development of Java 9 appears to be coming to an end.
Java 9 – The Ultimate Feature List
https://blog.takipi.com/java-9-the-ultimate-feature-list/
#WroteBy <Alex Zhitnitsky>
#Date <September 9, 2014>
-#lastUpdated: <November 20, 2014>
#Programming
#Java
by @D4NTESPARDA
https://blog.takipi.com/java-9-the-ultimate-feature-list/
#WroteBy <Alex Zhitnitsky>
#Date <September 9, 2014>
-#lastUpdated: <November 20, 2014>
#Programming
#Java
by @D4NTESPARDA
Takipi Blog
Java 9 - The Ultimate Feature List | Takipi Blog
All new features, expected features and speculations regarding the upcoming Java 9 release: the Jigsaw project, performance improvements and long awaited APIs
JDK 9
The goal of this Project is to produce an open-source reference implementation of the Java SE 9 Platform, to be defined by a forthcoming JSR in the Java Community Process.
The schedule and features of this release are proposed and tracked via the JEP Process, as amended by the JEP 2.0 proposal.
Schedule
2015/12/10 Feature Complete
2016/02/04 All Tests Run
2016/02/25 Rampdown Start
2016/04/21 Zero Bug Bounce
2016/06/16 Rampdown Phase 2
2016/07/21 Final Release Candidate
2016/09/22 General Availability
The milestone definitions are the same as those for JDK 8.
more at: https://openjdk.java.net/projects/jdk9/
Java SE 10
There is speculation of introducing objects without identity (value types), as well as moving towards 64-bit addressable arrays to support large data sets somewhere around 2018.
#LastUpdate: <2015/11/18 16:22>
#Programming
#Java
by @D4NTESPARDA
The goal of this Project is to produce an open-source reference implementation of the Java SE 9 Platform, to be defined by a forthcoming JSR in the Java Community Process.
The schedule and features of this release are proposed and tracked via the JEP Process, as amended by the JEP 2.0 proposal.
Schedule
2015/12/10 Feature Complete
2016/02/04 All Tests Run
2016/02/25 Rampdown Start
2016/04/21 Zero Bug Bounce
2016/06/16 Rampdown Phase 2
2016/07/21 Final Release Candidate
2016/09/22 General Availability
The milestone definitions are the same as those for JDK 8.
more at: https://openjdk.java.net/projects/jdk9/
Java SE 10
There is speculation of introducing objects without identity (value types), as well as moving towards 64-bit addressable arrays to support large data sets somewhere around 2018.
#LastUpdate: <2015/11/18 16:22>
#Programming
#Java
by @D4NTESPARDA