Hello,
I am having database primary and secondary filegroup. Few tables/indexes are partitioned on secondary filegroup for better performance.
But when I check activity monitor, I always see MDF & LDF files having response times under the Data Fil I/O but there is always 0 response time for NDF. Is this normal behaviour of MSSQL?
I am sure that table/indexes are on different filegroup and can see it in index properties. And the query we are running is for partitioned table but still NDF file response time looks 0.
Can anyone help me in understanding this behaviour?
regards,
Nitin