I search the Internet and did not find clear explanation if I have to try defragmenting physical database files when my DB resides on SAN. I understand that there are tools and procedures inside some SANs that deal with that, but also there are SANs which lack that features.
My question has 3 parts:
- How to check for physical fragmentation of SQL files?
- Is it necessary to do this if the files reside on SAN?
- Is it necessary to create a bigger physical database files to avoid fragmentation?