Research SQL Server 2016CTP2 – 1/13

Po zapowiedziach na początku maja w czasie konferencji Microsoft Ignite 2015 w USA pojawiła się długo oczekiwana ogólnie dostępna wersja CTP2 serwera bazodanowego firmy Microsoft – SQL Server 2016. Dzięki temu na wiele miesięcy przed premierą będziemy mogli sami zbadać i poznać wszystkie oferowane w niej nowości, a jest ich całkiem sporo, mimo że to [...]

I don’t have a SAN, so how many tempdb files do I need? Part 2 — PFS, GAM, and SGAM contention

In the previous article I don’t have a SAN, so how many tempdb files do I need? Part 1 — When splitting tempdb into to many files can be counterproductive to performance we saw that splitting tempdb into multiple files can be problematic. Now, it is time to have a closer look at the most [...]

I don’t have a SAN, so how many tempdb files do I need? Part 1 — When splitting tempdb into to many files can be counterproductive to performance

You can find some great and overwhelming load of not so good information about optimizing tempdb performance all over the Internet. This post has one purpose — to warn you of the consequences that you will face blindly following one of those “best practices”. Namely, if somebody tells you without even checking what your storage [...]