Friday, October 29, 2010

Meyyapan's sql fly demo.

He is a gifted speaker. Very down to earth but very sharp.
My taek away from the session is that:
1. Make sure there are no sort warnings. If that is happening , the cache is spilling to tempdb.
2. best practices like one file on tempdb per core may be counter producitonve if your streaming is geared for only sequential I/O. If you have SAn infra-structure then it can handle up to 16 streams. ?If that is the case , then we are better off leaving that stuff to SAN Admin to worry about it.
3. By granting slightly more memory thtan required for processing , we can trick teh sql engine to grant more memory that will make the query run faster.
4. We cna do all this watcihg file monitor as to which file it is writing to etc.

No comments:

Post a Comment