1、十几个客户端,使用访问速度正常.
2、服务器上操作,会出现间歇性变慢,一会正常,一会很慢,但是绝大部分时间是比较慢的,,,偶尔一个查询需要等几分钟。系统是Windows Server 2003 Sp2 求大神指点迷津啊。
2、服务器上操作,会出现间歇性变慢,一会正常,一会很慢,但是绝大部分时间是比较慢的,,,偶尔一个查询需要等几分钟。系统是Windows Server 2003 Sp2 求大神指点迷津啊。
还有没有其他原因导致的啊
Avg.Disk QueueLength::4.821
Avg.Disk Sec/Read:0.016
Avg.Disk Sec/Transfer:0.033
Avg.Disk Sec/Write :0.033
Avg.Disk Queue Length 4.865性能监视器显示的值,不知道是否有什么可以优化的地方啊
select top 10 wait_type,wait_time_ms
from sys.dm_os_wait_stats
order by wait_time_ms desc
sqltrace_buffer_flush 23936125
oledb 4062218
waitfor 1169671
sleep bpool_flush 96515
sync_network_io 13625
io_completion 13531
pageiolatch_up 8859
pageiolatch_sh 8234
老大,帮忙分析下哈。。
LAZYWRITER_SLEEP
Occurs when lazywriter tasks are suspended. This is a measure of the time spent by background tasks that are waiting. Do not consider this state when you are looking for user stalls.SQLTRACE_BUFFER_FLUSH
Occurs when a task is waiting for a background task to flush trace buffers to disk every four seconds.
原文 http://technet.microsoft.com/en-us/library/ms179984.aspx
唐诗的建议:
1.检查SQL内存设置,动态分配即可.
2.检查SQL2005 SP3安装了没.