# Catatan Seekor SQL Server

* [Does a Query always wait in the SUSPENDED State?](https://www.sqlpassion.at/archive/2018/06/05/does-a-query-always-wait-in-the-suspended-state/)
* [Five SQL Server Settings to Change](https://www.brentozar.com/archive/2013/09/five-sql-server-settings-to-change/)
* [How to avoid SUSPENDED Status for my SPID running a Select statement?](https://social.msdn.microsoft.com/Forums/sqlserver/en-US/ddcaf323-b9e1-4bd3-8b2f-bbf547e70334/how-to-avoid-suspended-status-for-my-spid-running-a-select-statement)
* [**How to find out why the status of a spid is suspended? What resources the spid is waiting for?**](https://stackoverflow.com/questions/22038695/how-to-find-out-why-the-status-of-a-spid-is-suspended-what-resources-the-spid-i)
* [MS Sql Server getting overloading with 'Suspended' queries, mostly reads. Any way to fix this?](https://serverfault.com/questions/578533/ms-sql-server-getting-overloading-with-suspended-queries-mostly-reads-any-wa)
* [What does a Status of “Suspended” and high DiskIO means from sp\_who2?](https://stackoverflow.com/questions/17817177/what-does-a-status-of-suspended-and-high-diskio-means-from-sp-who2)
* [sp\_who (Transact-SQL)](https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-who-transact-sql)
* [What is the CXPACKET Wait Type, and How Do You Reduce It?](https://www.brentozar.com/archive/2013/08/what-is-the-cxpacket-wait-type-and-how-do-you-reduce-it/)