SQL Server Interview | How to approach analysis if sql server started running really slow
Вставка
- Опубліковано 11 січ 2015
- SQL Server Interview Question Answer
"All the sudden, users start complaining that the SQL Server is running slow. What steps you would take to analysis the problem?"
Complete List of SSIS Interview Questions by Tech Brothers
sqlage.blogspot.com/search/lab... - Наука та технологія
I would get a visual on the actual problem, then drill down to the source of the problem, either taking the route to the database, or to the application. It wouldn't be the first time a problem is announced, and the problem actually is on the other end.
how do i write a query to remove permissions such as create table, insert, update, and execute from a user?
if slowness reported yesterday and asking analysis today how to collect?
how to check for deadlocks?
enable trace on (1222,-1)
By using this command
Dbcc Traceon (3605,1204,-1)
There are Many Ways.. Enable Traceflags and Check in Errorlogs. and By Using Exteneded Events we can find Deadlocks