Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How can i find which tables are read/write intensive within sql server 2005 Expand / Collapse
Author
Message
Posted Monday, September 30, 2013 5:15 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, October 14, 2013 4:47 AM
Points: 3, Visits: 27
How can i find which tables are read/write intensive within sql server 2005

Really would appreciate some help on this guys and gals....
Post #1499931
Posted Monday, September 30, 2013 8:56 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 2:05 PM
Points: 13,327, Visits: 12,820
dba_track (9/30/2013)
How can i find which tables are read/write intensive within sql server 2005

Really would appreciate some help on this guys and gals....


What are you looking for? Not sure what you mean by "read/write intensive".


_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1500050
Posted Monday, September 30, 2013 9:04 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, October 14, 2013 4:47 AM
Points: 3, Visits: 27
What i mean is is to find some sort of stats on how many times all the tables within any given database is read from and written to - either based upon a profile trace OR from querying a DMV or a collection of DMVs..

Thanks
Post #1500056
Posted Monday, September 30, 2013 9:14 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 2:05 PM
Points: 13,327, Visits: 12,820
dba_track (9/30/2013)
What i mean is is to find some sort of stats on how many times all the tables within any given database is read from and written to - either based upon a profile trace OR from querying a DMV or a collection of DMVs..

Thanks


This is a challenge to be 100% accurate but you can use a couple of DMVs to help identify them.

http://technet.microsoft.com/en-us/library/ms174281.aspx

http://technet.microsoft.com/en-us/library/ms188755.aspx


_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1500063
Posted Monday, September 30, 2013 9:17 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, October 14, 2013 4:47 AM
Points: 3, Visits: 27
Thank you for that... I 'll definately read up on those articles.

In the meantime what is your opinion on the following query?

select sum(reads) as Reads, sum(writes) as Writes
from DB_NAME
where TextData like '%TABLENAME%'
(this would be querying an output from trace data gained from profiler)

Would that be right in this context? Thanks
Post #1500064
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse