Looking for a good SQL Server 2019 Admin book with SQL performance, optimization , with some internals

Question

Looking for a good SQL Server 2019 Admin book with SQL performance, optimization , with some internals - with content different than what is normally available online with some practical examples etc. Please suggest couple in this category.

Answer 1

Hi Swguy-2130,

How are things going? Is the answer helpful?
You can take a look at SQL Server technical documentation, which also has practical examples.
And please also check Microsoft Learn, which has many courses for SQL Server. https://learn.microsoft.com/en-us/search/?terms=performance&category=Learn&products=%2Fdevrel%2Fcbe4ca68-43ac-4375-aba5-5945a6394c20

Best Regards,
Amelia

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Good day @Swguy

Your question does not fit the forum!

It is an opening for abusing by advertisements and has nothing to do with technical question that we can help you solve.

There are searching engine which are designed foe searching Like Google and Bing. Try using one of these to get tens of books. In anyway most books will not cover everything you mentioned and you might need to start learning topic by topic, book by book.

Administrating databases is a topic stand by itself, performance is something that can be learned in a week at least and it is another topic that stand together with optimization usually by itself, and internals is something in a different level (if you focus only on internals related to performance then it might be in the same book)

Here is the answer to your question:

https://www.google.com/search?q=sql+server+performance+internals+book&oq=sql+server+performance+internals+book

Tip! Select the book not by it's cover, not by recommendation online from people you do not know, but mostly by the author

Tip2! Number of edition the book is published might (not always!) say something about the book success, but at the same time it might suggest old info. Make sure that the book content is updated to the latest server version! Microsoft improve the server in each version, adding new features and new objects (for example functions, procedures, DNM and so on) which are directly relevant to performance. Learning from book that was written in 2005 might help to understand basic but will not bring you updated options which are relevant to SQL Server 2019 for example.

----------

Ronen Ariely
Personal Site | Blog | Facebook | Linkedin

Answer 3

Thanks @Ronen Ariely

Apologies for posting the question here. Didn't know that this was a forum meant only for technical questions.
Actually I was directed to this from another MS site.

Thanks for the answer !