Primary and Secondary Filegroup

• nshete

  SSC Enthusiast

  Points: 113

  More actions

  November 28, 2024 at 2:10 pm

  #4490506

  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

   

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  November 29, 2024 at 3:10 pm

  #4490923

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• February 5, 2025 at 5:30 am

  This was removed by the editor as SPAM