Sometimes, we need to understand what exactly going on with particular statement, stored procedure why it is slow?
To check performance of statement what exactly going on we also interested how many logical reads, physical reads a particular statement taking.
To achieve this we need to write SET STATISTICS IO ON
For example
GO
SET STATISTICS IO ON
SELECT * FROM [dbo].[RequestMaster]
SET STATISTICS IO OFF
GO
If your statement having large number of physical reads & logical reads then you need to think for optimization.
Enjoy
To check performance of statement what exactly going on we also interested how many logical reads, physical reads a particular statement taking.
To achieve this we need to write SET STATISTICS IO ON
For example
GO
SET STATISTICS IO ON
SELECT * FROM [dbo].[RequestMaster]
SET STATISTICS IO OFF
GO
If your statement having large number of physical reads & logical reads then you need to think for optimization.
Enjoy
No comments:
Post a Comment