每间隔一段时间SQL SERVER的cpu 占用率100%，求帮忙

[yzflying]

一个网站采用ASP+MS SQL2000构建的，最近重启服务器后发现，间隔一段时间CPU占用率都是100%
采用事件探查后发现以下情况，请问能查出什么原因吗？没有死锁的进程。
RPC:Completed exec sp_cursor 180150001, 40, 1 Internet Information Services sq_yzkdfcw 0 30 0 0 6000 67 2013-05-08 01:15:52.530
RPC:Completed exec sp_cursor 180150001, 40, 1 Internet Information Services sq_yzkdfcw 0 30 0 0 6000 67 2013-05-08 01:15:52.530
RPC:Completed exec sp_cursor 180150001, 40, 1 Internet Information Services sq_yzkdfcw 0 30 0 0 6000 67 2013-05-08 01:15:52.530
RPC:Completed exec sp_cursor 180150001, 40, 1 Internet Information Services sq_yzkdfcw 0 30 0 0 6000 67 2013-05-08 01:15:52.530
RPC:Completed exec sp_cursor 180150001, 40, 1 Internet Information Services sq_yzkdfcw 0 30 0 0 6000 67 2013-05-08 01:15:52.530
SQL:BatchCompleted Select Top 6 yzvod_Website.ID,yzvod_Website.Color,yzvod_Website.Sort,yzvod_Website.ShopID,yzvod_Shop.Name,yzvod_Shop.Alias,yzvod_Shop.Website,yzvod_Shop.Address,yzvod_Shop.Tel,yzvod_Shop.Guestbook,MapLng From yzvod_Website INNER Join yzvod_Shop On yzvod_Website.ShopID=yzvod_Shop.ID Where yzvod_Website.Flag=1 And yzvod_Website.CategoryID=34 Order By yzvod_Website.Sort Asc Internet Information Services sq_yzvod 0 143 0 0 5796 58 2013-05-08 01:15:52.530
RPC:Completed exec sp_cursoroption 180150001, 1, 0 Internet Information Services sq_yzkdfcw 0 0 0 0 6000 67 2013-05-08 01:15:52.530
RPC:Completed exec sp_cursorfetch 180150001, 16, 742, 1 Internet Information Services sq_yzkdfcw 0 27 0 0 6000 67 2013-05-08 01:15:52.530
RPC:Completed exec sp_cursoroption 180150001, 3, 2 Internet Information Services sq_yzkdfcw 0 0 0 0 6000 67 2013-05-08 01:15:52.530
RPC:Completed exec sp_cursor 180150001, 40, 1 Internet Information Services sq_yzkdfcw 0 30 0 0 6000 67 2013-05-08 01:15:52.530
RPC:Completed exec sp_cursor 180150001, 40, 1 Internet Information Services sq_yzkdfcw 0 30 0 0 6000 67 2013-05-08 01:15:52.530
RPC:Completed exec sp_cursor 180150001, 40, 1 Internet Information Services sq_yzkdfcw 0 30 0 0 6000 67 2013-05-08 01:15:52.530
RPC:Completed exec sp_cursor 180150001, 40, 1 Internet Information Services sq_yzkdfcw 0 30 0 0 6000 67 2013-05-08 01:15:52.530
RPC:Completed exec sp_cursor 180150001, 40, 1 Internet Information Services sq_yzkdfcw 0 30 0 0 6000 67 2013-05-08 01:15:52.530
RPC:Completed exec sp_cursor 180150001, 40, 1 Internet Information Services sq_yzkdfcw 0 30 0 0 6000 67 2013-05-08 01:15:52.530
RPC:Completed exec sp_cursor 180150001, 40, 1 Internet Information Services sq_yzkdfcw 0 30 0 0 6000 67 2013-05-08 01:15:52.530
RPC:Completed exec sp_cursoroption 180150001, 1, 0 Internet Information Services sq_yzkdfcw 0 0 0 0 6000 67 2013-05-08 01:15:52.530
RPC:Completed exec sp_cursorfetch 180150001, 16, 743, 1 Internet Information Services sq_yzkdfcw 0 27 0 16 6000 67 2013-05-08 01:15:52.530
RPC:Completed exec sp_cursoroption 180150001, 3, 2 Internet Information Services sq_yzkdfcw 0 0 0 0 6000 67 2013-05-08 01:15:52.547
RPC:Completed exec sp_cursor 180150001, 40, 1 Internet Information Services sq_yzkdfcw 0 30 0 0 6000 67 2013-05-08 01:15:52.547
RPC:Completed exec sp_cursor 180150001, 40, 1 Internet Information Services sq_yzkdfcw 0 30 0 0 6000 67 2013-05-08 01:15:52.547
RPC:Completed exec sp_cursor 180150001, 40, 1 Internet Information Services sq_yzkdfcw 0 30 0 0 6000 67 2013-05-08 01:15:52.547
RPC:Completed exec sp_cursor 180150001, 40, 1 Internet Information Services sq_yzkdfcw 0 30 0 0 6000 67 2013-05-08 01:15:52.547


exec sp_cursor 180150001, 40, 1 为什么会频繁执行呢？

[發糞塗牆]

sp_cursor 这个是你们自己写的吗？貌似没有这个系统存储过程

[黄_瓜]

引用 3 楼 DBA_Huangzj 的回复:

sp_cursor 这个是你们自己写的吗？貌似没有这个系统存储过程

你确定没有？

[yzflying]

这个存储过程我没有写，已经找到原因，是ASP程序中的循环语句DO WHILE。。执行SQL时候，自动产生的。

[Q315054403]

大量的游标。。若能改写程序，是最佳改善方法 若不能改写程序，得看数据库结构是如何的。。应该是有优化的空间

[yzflying]

我们的网站程序，没有使用游标呀