SQL Server DBA Tutorial 143-How to Find out How Much Memory is Allocated to SQL Server Instance

preview_player
Показать описание
In this video you will learn how to find how much memory is allocated to SQL Server instances using various methods. Methods include by viewing SQL Server memory configuration via SSMS, using SQL Server dynamics system view and how to configure SQL Server Minimum (min) and Maximum (Max) memory using SQL Server Memory Configuration.

Blog post link for the video with script

Visit our website to check out SQL Server DBA Tutorial Step by Step
Рекомендации по теме
Комментарии
Автор

it was very simply explained. Thank you

Laughing_out_loud_
Автор

We allocated 0kb to the database
We are unable to login to the database now

Any suggestions ??

nareshegadandi
Автор

You didn't say why you picked 512 mb min and 4096 mb max

arthurclass