Hello, I am facing slowness issue on my SQL 2000 Server with Std edition. Actually, there is lot's of processes is running on server but which goes in Sleeping mode. When i checked in Sysprocesses, it shows me LastWait Type is WriteLog. I assume that it is writing a log so that i changed database growth pattern and make it to 500 MB for data and log each. I have also changes parellilesam and set to 2 ( As i am usingt 4 CPU), but still our processes is not showing in runnable state. Do anyone help me to increase performance?