• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 276
  • Last Modified:

How sql stores how many SELECT statements hit on a particular table.?

Please answer my two questions

1) How's Sql Server stroring the no.of SELECT statements hitting on a table..?

2) Where does Sql Server store updated data (older data) during a transaction..?

Thanks in advance..
0
josebirla
Asked:
josebirla
1 Solution
 
Dishan FernandoSoftware Engineer / DBACommented:
1. ??
2. Inserted and Deleted Tables. You can Use it within Trigger.
0
 
rajesh009Commented:
Hi,
 
1)  AFAIK SQL server does not store the no. SELECT statements hitting on a table.

2) Older data are stored in deleted table, to be precise, prior to commit being issued. This table can be accessed in a before insert or update trigger. New data is stored in inserted table.

Thanks,
Rajesh.
0
 
LowfatspreadCommented:
your select question
are you actually asking about how SQL server control concurrency?
e.g. Database Locking

if so read BOL on locking
and look at the system table syslockinfo


hth
0
 
pegasysCommented:
Take a look at the SQL Transaction logs. (Enterprise manager is the best way to see these). They are files that store ALL transactions, ie. selects, inserts, deletes etc... to and from the SQL databases...
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now