I have successfully added several calculated fields to different tables, for example:
ALTER TABLE dbo.tblBGiftVoucherItem ADD isUsGift AS CAST( ( ISNULL( CASE WHEN sintMarketID = 2 AND strType = 'CARD' AND strTier1 LIKE 'GG%' THEN 1 ELSE 0 END ,0) ) AS BIT) PERSISTED;
This doesn't seem to have had any impact on write performance on the involved table, in this case
However, when I have added indexed views, especially those which touch more than one table with an
INNER JOIN, I have noticed a considerable increase on the number of deadlocks directly related to the tables in question.
What DMVs can I use that will give me an indication of I/O pressure by database object?
For example the table
dbo.tblBGiftVoucherItem from the example above.
Is there any way I can measure/monitor how long the storage engine is taking to deal with writing requests specifically related to this table?
If I knew this I would have a better idea of how many calculated fields I could add to the table, and the cost involved in each of them.
Same with the indexed views.