Browse by Tags

• copy
• css
• dmv
• dump
• enterprise manager
• expensive query
• identity
• instances
• memory
• performance
• physical
• reads
• script
• select
• size
• system resources
• technet
• top
• tsql
• vbscript
• writes

Copy the SQL Server instances list from Enterprise Manager using vbscript
07 February 08 01:34 AM | SQL Master | 2 Comments   

As you may be aware you can take help of Registry settings in order to copy the SQL Server list that are managed from the Central Managed server. I have seen this VBScript posted by Mohammed U posted the following script, you can save it as .VBS that Read More...

Filed under: sql server, enterprise manager, script, instances, microsoft, copy, vbscript

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

Identifying top 20 most expensive queries in terms of read I/O (referred from Technet Magazine)
15 November 07 06:16 AM | SQL Master | 2 Comments   

It is worth mentioning the valueable query I have been through when referring to Technet Magazine, the following query has given me useful information in finding out what are my top 20 most expensive queries that are consuming most of disk I/O (read & Read More...

Filed under: reads, system resources, expensive query, tsql, sql server, performance, identity, dmv, top, technet, writes, microsoft