When any connection starts the value of the SET LOCK_TIMEOUT is -1, which means that the query has to wait for infinite time for the lock to be released on another query. If you want to simulate the scenario of SET LOCK_TIMEOUT to match NOWAIT query hint, it should be set to value 0. //blog.sqlauthority.com/2013/01/28/sql-server-basic-explanation-of-set-lock_timeout-how-to-not-wait-on-locked-query/ In this […]
If disk space on your SECONDARY side is full and you want to move one of your databasefile to other location. You can manage in 3 steps: ALTER DATABASE LogShipped_DB MODIFY FILE ( NAME = myLogShip, FILENAME = ‘D:\SQLMonitor\LogShip.mdf’ ); With this command, you have indicated that you are going to move datafile to sql […]
You need to add new datafile to your SQL SERVER that has LOGSHIPPING. So automatically same datafile will be created on secondary side. What if drive letter is different on secondary node? To manage you sould run this command on secondary side to tell sql server to create datafile on where you want.
1- Not based on Table design, based on load As soon as creating table, you don’t need to create whole indexes. Observing loads and managing indexes would be better. 2- Size of Table boyutları Most of the operating systems read data from disk with a 64KB packages. So if your table is small (lets say […]
You can list all errors getting from SQL Mail and than perform troubleshooting : select * from sysmail_allitemsorder by sent_date desc
You can get information about your operating system ,cpu and versions that your SQL is running on: SELECT @@SERVERNAME AS [Server Name], @@VERSION AS [SQL Server and OS Version Info]; gives your server name and SQL SERVER version SELECT @@SERVERNAME AS [Server Name], createdate AS [SQL Server Install Date] FROM sys.syslogins WHERE loginname = N’NT […]
PLE UnfortRAMs are limited Unfortunately, RAMs are limited and SQL Server needs memory. If you wonder that you have any memory bottleneck, PLE is the great measure to look at. As summary PLE is the time that your data remains in cache. If PLE is more than thousands that is OK for SQL Server. All […]
Tüm veritabanı sistemlerinde olduğu gibi SQL Server’da da memory 2 farklı amaç için kullanılır: Kendi iç sistemleri (plan cache, bazı denetim DLL dosyaları ve çalışan kodlar, procedure cache vs) için ayrılan diğer kısma göre küçük kalacak bir alan Diskten okuma yazma işlemlerini azaltmak amaçlı kullanılan ve SQL için ayrılan memory’nin büyük kısmını oluşturan “Buffer Cache” […]