Foxhound is the better* Database Monitor for SQL Anywhere.
*better: More thorough, more relevant, more effective.
...more Alerts, more All Clears, more details, more control in your hands.


[Home] [Back to Tip 79] [Forward to Tip 81] [Archives]

Breck Carter
Last modified: October 28, 1998
mail to: bcarter@bcarter.com

Tip 80: SQL Server Performance Tips

Changes since October 23 are marked . Introduction

This is a work in progress. It is not a "how to", just a "quick tips" or "idea list". It is also NOT exhaustive.

[Top]


Devices And Databases

[Top]


Run sp_who

[Top]


Run sp_lock

[Top]


Run sp_monitor

sp_monitor
last_run current_run seconds -------- ----------- ----------- Oct 21 1998 2:17PM Oct 22 1998 4:17PM 93606 cpu_busy io_busy idle -------- ------- ---- 26(20)-0% 155(153)-0% 18983(18955)-20% packets_received packets_sent packet_errors ---------------- ------------ ------------- 22756(22315) 10711(10332) 2(2) total_read total_write total_errors connections ---------- ----------- ------------ ----------- 15855(15312) 35308(30443) 0(0) 0(0)

[Top]


Run sp_sysmon

sp_sysmon begin_sample
go

[run your test script here, or just wait while other stuff runs]

sp_sysmon end_sample
go

[Top]


Optimize SELECTs

[Top]


Optimize Cursors

[Top]


Set Showplan On

[Top]


[Home] [Back to Tip 79] [Forward to Tip 81] [Archives] [mail to: bcarter@bcarter.com]