Browse by Tags

• blackbox
• css
• dump
• memory
• microsoft
• performance
• physical
• profiler
• select
• sql server
• trace

SQL Server: Creating BlackBox kind of trace with TSQL
28 May 08 04:59 AM | SQL Master | 2 Comments   

Here is the kind of scripts defined within TEchnet articles about running black-box kind of traces against your SQL Server instance, then also you can take advantage of the blackbox trace if you are facing intermittent problems, you want to make sure Read More...

Filed under: tsql, sql server, trace, profiler, size, blackbox

How to use TSQL to find the size of total and free physical memory within the SQL Server?
24 January 08 03:28 PM | SQL Master | 2 Comments   

Recently I have to search for the information on the total size of free physical memory on the SQL Server which is causing lots of performance issues, when reported to CSS they have supplied the following TSQL to get more information in this regard: With Read More...

Filed under: tsql, sql server, performance, memory, select, microsoft, physical, dump, size, css