September 30, 2013 at 5:15 am
How can i find which tables are read/write intensive within sql server 2005
Really would appreciate some help on this guys and gals....
September 30, 2013 at 8:56 am
dba_track (9/30/2013)
How can i find which tables are read/write intensive within sql server 2005Really 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 Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
September 30, 2013 at 9:04 am
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
September 30, 2013 at 9:14 am
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 Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
September 30, 2013 at 9:17 am
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
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply