SQL Server, Memory Manager Object

SQL Server, Memory Manager ObjectSQL Server, Memory Manager Object
The Memory Manager object in Microsoft SQL Server provides counters to monitor overall server memory usage. Monitoring overall server memory usage to gauge user activity and resource usage can help you to identify performance bottlenecks. Monitoring the memory used by an instance of SQL Server can help [...]

Detecting Cache Bottlenecks

Detecting Cache Bottlenecks
http://technet.microsoft.com/en-us/library/cc722473.aspx

Memory Performance

select * from master.dbo.sysperfinfo where counter_name like ‘%server memory%’
exec sp_configure ‘max server memory’, 3072
reconfigure
go
exec sp_configure ‘min server memory’, 0
reconfigure
go

Can’t get Perfmon to save data to Database

There is a common problem when Logging Perfmon counter to a SQL Table - Security.
The user used to log Perfmon counters into database must be a member of the perfmon group and it must have access to SQL Server (memeber of sysadmin role).
Error message will be something like:
The service was unable to open the log [...]

SQLQueryStress

What is SQLQueryStress?
SQLQueryStress is a free tool for SQL Server programmers. It is designed to assist with performance stress testing of T-SQL queries and routines. The tool automatically collects metrics to help you determine whether your queries will perform under load, and what kind of resource strain they put on your server.

SQLQueryStress Documentation
Download Page

http://www.datamanipulation.net/sqlquerystress/

Execution Plan

select * from sysobjects where name = ‘WEB_FETCHgetJournalIssue’
select * from master..syscacheobjects where objid = 924634437

SQL Nexus Tool

What is SQL Nexus?
SQL Nexus is a tool that helps you identify the root cause of SQL Server performance issues. It loads and analyzes performance data collected by SQLDiag and PSSDiag. It can dramatically reduce the amount of time you spend manually analyzing data.
Check link below for free download:
http://sqlnexus.codeplex.com/Wiki/View.aspx?title=SqlNexusReports

Process Explorer v11.33

Great tool.
http://technet.microsoft.com/en-us/sysinternals/bb896653.aspx
Tips:
http://forums.techguy.org/windows-nt-2000-xp/563082-solved-100-cpu-usage-cidaemon.html

LIST ALL TABLES WITHOUT A CLUSTERED INDEX

select * from sysobjects where xtype = ‘U’ and id not in (select id from sysindexes where indid = 1)