But, when I run script posted by "Kenneth Langner Jr." On adventureworks database I get index_space_mb as [0.0781250] for [Sales].[Individual] table

whereas sp_spaceused returns index_size of [49928 KB]...

Moin,

As per http://www.sqlservercentral.com/scripts/Backup/62497/ try it:-

From this you can get a pretty good idea of how fast your database is growing.

select

BackupDate = convert(varchar(10),backup_start_date, 111)

,SizeInGigs=floor( backup_size/1024000000)

from msdb..backupset...

-- Which queries are causing the most IO operations (can take a few seconds)

SELECT TOP (20) total_logical_reads/execution_count AS [avg_logical_reads],

total_logical_writes/execution_count AS [avg_logical_writes],

total_worker_time/execution_count AS...

Thanks Bryan. You could have granted 'view definition permission' to that user under that database for the same too.

If yours is enterprise edition then you can make use of online reindexing.

Track SQL server memory using below mentioned code.

SELECT OBJECT_NAME

,Counter_Name

,( cntr_value / 1024 ) AS [Counter Value (MB)]

FROM sys.dm_os_performance_counters

WHERE OBJECT_NAME LIKE 'SQLServer:Memory Manager%'

AND counter_name LIKE 'Target Server Memory (KB)%'

Download http://www.sysinternals.com/Utilities/ProcessExplorer.html and...

Use Sys.dm_exec_requests DMV to find the currently active requests, their associated TSQL statement, and the corresponding query plan that is allocating most space resources in tempdb. Grab sql from this.

SELECT...

select o.name as TbName , xc.name as ColName

from sysobjects o

inner join syscolumns xc

...

Thanks for sharing the code.

Could you please share the system view name you granted permission on?

MJ

Ravi,

My question is specific to sql 2005. Your link is for sql 2k.

Anyone?

Passwords are just stored in global variables in dts packages.

Thanks in advance,

Manu

You can see checkpoint info. Run this under the affected db.

SELECT

DB_NAME() AS DatabaseName

, [Current LSN]

, [Previous LSN]

, Operation

, [Checkpoint Begin] ...

Could you please shar that script, I am in need of it.

Thanks,

MJ