<div>
you can get a row count (table info) with out waiting.... use this: 
 
;WITH table_space_usage(filegroup,schema_name,table_name,index_name,used,reserved,ind_rows,tbl_rows) 
&nbsp; &nbsp; &nbsp;AS (SELECT ds.[name] &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; AS filegroup, 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; s.name, 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; o.name, 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Coalesce(i.name,'HEAP'), 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Cast(p.[used_page_count] AS BIGINT) * 8, 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Cast(p.[reserved_page_count] AS BIGINT) * 8, 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Cast(p.[row_count] AS BIGINT) AS [rows], 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CASE 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; WHEN i.index_id IN (0,1) THEN p.[row_count] 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ELSE 0 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; END 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;FROM &nbsp; sys.dm_db_partition_stats p 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; INNER JOIN sys.objects AS o 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ON o.object_id = p.object_id 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; INNER JOIN sys.schemas AS s 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ON s.schema_id = o.schema_id 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; LEFT OUTER JOIN sys.indexes AS i 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ON i.object_id = p.object_id 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AND i.index_id = p.index_id 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; LEFT JOIN sys.data_spaces ds 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ON ds.[data_space_id] = i.[data_space_id] 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;WHERE &nbsp;o.type_desc IN ('USER_TABLE','VIEW') 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; AND o.is_ms_shipped = 0) 
SELECT &nbsp; t.table_name, 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Sum(t.tbl_rows) &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;tbl_rows, 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Sum(Cast(t.reserved / 1024.0 AS DECIMAL(9,2))) &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; AS reserved_in_mb, 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Sum(Cast(t.used / 1024.0 AS DECIMAL(9,2))) &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; AS used_in_mb, 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(Sum(Cast(t.used * 1024.0 AS FLOAT)) + 1.0) / (Sum(Cast(t.tbl_rows AS FLOAT)) + 1.0) AS avg_row_size_bytes 
FROM &nbsp; &nbsp; table_space_usage AS t 
GROUP BY t.table_name 
ORDER BY reserved_in_mb DESC 

</div>

<div>
<div class="content wysiwyg-content">
I've begun a consulting assignment and find an extremely slow database with a confused political environment where it's not clear who's responsible for what? &nbsp;As an example, getting the count from a table (admittedly large with about 6 million rows) took more than 4 minutes. 
 
I'd like to get some feel for how this database is being maintained on my own and I'm wondering if there is anything available in the sys tables that would indicate when UpdateStatistics was last run on a given table. &nbsp;Also, is there any way to determine when an index was created?
</div>
</div>

I've begun a consulting assignment and find an extremely slow database with a confused political environment where it's not clear who's responsible for what?  As an example, getting the count from a table (admittedly large with about 6 million rows) took more than 4 minutes.

I'd like to get some feel for how this database is being maintained on my own and I'm wondering if there is anything available in the sys tables that would indicate when UpdateStatistics was last run on a given table.  Also, is there any way to determine when an index was created?

Performance issues

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.