I have enabled the trace flag and extended events to capture the deadlock. I can now able to capture and see the deadlock graph using extended events. However, how can...

Thanks! One question, does "auto growth off" option is that a good practice for tempdb? Not sure if some will argue on this. In my case what i noticed is...

Thanks! So it's always good practice to go multiple tempdb data files based on CPUs. So my understanding is since SQL 2016 installation there is a option to configure multiple...

Thanks. Tempdb growth is a situation that can't be avoided as always right? It can happen with multiple reasons as everyone else stated here. To avoid the situation of tempdb...

Thanks SP_help_revlogin creates the new login with same password. However, i tried another option is right click login and generate the script that would not create the same password and...

Thanks Jeff. The Low PLE value is less than 300 secs. The total memory on the server is 8GB and 4 GB is assigned to SQL Server. After looking into...

Thanks for the response. So you saying catch deadlock errors and retry a certain number of times? How about return the records we want from a memory cache, no longer...

Thanks!  Sorry, I want to take it back what i said previously, it's a vendor product but it does have some user dbs and vendor db's. Under the heavy load...

Thanks. It is a vendor product so i am not sure if i can look for any inefficient query's? Just expansion of drive would be the option?

Would that transfer the passwords for sql account?

So periodically save the contents of sys.dm_exec_sessions to a table would be a good option?

So you saying there won't be any Orphans? How about the passwords for SQL Account? Would that be moved with SP_helprevlogin?

As a part of upgrade, I have restored the databases to different server but forgot to create the Logins. So would that cause orphans on the new server? Since the...

Thanks for the info. Actually i would need to capture the information of logins which are not logged in over 120 days and build a query so someone would run...

So there won't be true consistent last login then? I will need to be able to identify haven't logged in for over 120 days however, our servers are rebooted every...