TO DISABLE FIBER MODE (LIGHHTWEIGHT POOLING)

--TO DISABLE FIBER MODE (LIGHHTWEIGHT POOLING)

sp_configure 'show advanced options', 1;

GO

RECONFIGURE;

GO

sp_configure 'lightweight pooling', 0;

GO

RECONFIGURE;

GO