<div>
<div class="content wysiwyg-content">
I have a table that is using a lot more memory than other tables. I ran a query using sys.dm_db_index_usage_stat<wbr />s. I'm new to this and wanted to see if I could get some help. The table has a PK index on it. Can you explain what I'm seeing? The results of my query show:<br />
<br />
user_seeks<br />
213873<br />
user_scans<br />
3553<br />
user_lookups<br />
30400<br />
user_updates<br />
230854<br />
SizeMB<br />
24649
</div>
</div>


I have a table that is using a lot more memory than other tables. I ran a query using sys.dm_db_index_usage_stats. I'm new to this and wanted to see if I could get some help. The table has a PK index on it. Can you explain what I'm seeing? The results of my query show:

user_seeks
213873
user_scans
3553
user_lookups
30400
user_updates
230854
SizeMB
24649

sys.dm_db_index_usage_stats

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.