SqlServerKudos - Stories tagged with Tips and Tricks

Tips and Tricks

atom rss
1
kudos
spam Kudos Remove

Get Query Plan Along with Query Text and Execution Count
published 998 days, 15 hours, 54 minutes ago posted by sasa 1004 days, 17 hours, 10 minutes ago
Thursday, August 27, 2009 8:29:36 PM GMT Friday, August 21, 2009 7:13:52 PM GMT
Get Query Plan Along with Query Text and Execution Count
Quite often, we need to know how many any particular objects have been executed on our server and what their execution plan is. I use the following handy script, which I use when I need to know the details regarding how many times any query has ran on my server along with its execution plan. You can add an additional WHERE condition if you want to learn about any specific object. SELECT cp.objtype AS ObjectType, OBJECT_NAME(st.objectid,st.dbid) AS ObjectName, cp.usecounts AS ExecutionCount, st.TEXT A... (more)
category: Query | clicked: 2 | comment | | source: blog.sqlauthority.com
tags: Authority, Performance, Query, Scripts, System Table, T SQL, Tips and Tricks
1
kudos
spam Kudos Remove

SQL SERVER – Measure CPU Pressure – CPU Business
published 1000 days, 23 hours, 4 minutes ago posted by sasa 1009 days, 9 hours, 26 minutes ago
Tuesday, August 25, 2009 1:19:45 PM GMT Monday, August 17, 2009 2:57:21 AM GMT
SQL SERVER – Measure CPU Pressure – CPU Business
Many a time, DBAs face the following question: can the CPU handle the current transaction? I have seen many DBAs getting confused on whether they should get a CPU with higher clock speed or more number of CPUs when it is time to upgrade system. As we all know, the CPU (or the Central Processing Unit) is the core of any system. The CPU is responsible for not only SQL Server operations but also all the OS (Operating System) tasks related to the CPU on the server. It is quite possible that although we are ... (more)
category: Management | clicked: 2 | comment | | source: blog.sqlauthority.com
tags: Authority, Performance, Scripts, SQL System Table, Technology, Tips and Tricks, TSQL
Previous 1 2 3 Next