Is there any tool available by which one can calculate (a)the size or a single row in sqlserver (b)the amount of traffic hitting the sqlserver

Question

Is there any tool available by which one can calculate the size or a single row in sqlserver. This would really help in calculating the expected size of DB. Further one option can be to use sp_spaceused but it gives the details of the whole table... what we want is the size of a record (maximum size) in a table.

Further is there any tool to check the amount of traffic that is hitting the server so as to enable to identify the bottlenecks.

Thanks in advance.

Answer 1

You don't need a tool for this, it's a very simple query to write:

SELECT SUM(length)
FROM syscolumns
WHERE id = OBJECT_ID('MyTable')