每间隔一段时间SQL SERVER的cpu 占用率100%，求帮忙
一个网站采用ASP+MS SQL2000构建的，最近重启服务器后发现，间隔一段时间CPU占用率都是100%
采用事件探查后发现以下情况，请问能查出什么原因吗？没有死锁的进程。
RPC:Completedexec sp_cursor 180150001, 40, 1Internet Information Servicessq_yzkdfcw030006000672013-05-08 01:15:52.530
RPC:Completedexec sp_cursor 180150001, 40, 1Internet Information Servicessq_yzkdfcw030006000672013-05-08 01:15:52.530
RPC:Completedexec sp_cursor 180150001, 40, 1Internet Information Servicessq_yzkdfcw030006000672013-05-08 01:15:52.530
RPC:Completedexec sp_cursor 180150001, 40, 1Internet Information Servicessq_yzkdfcw030006000672013-05-08 01:15:52.530
RPC:Completedexec sp_cursor 180150001, 40, 1Internet Information Servicessq_yzkdfcw030006000672013-05-08 01:15:52.530
SQL:BatchCompletedSelect 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 AscInternet Information Servicessq_yzvod0143005796582013-05-08 01:15:52.530
RPC:Completedexec sp_cursoroption 180150001, 1, 0Internet Information Servicessq_yzkdfcw00006000672013-05-08 01:15:52.530
RPC:Completedexec sp_cursorfetch 180150001, 16, 742, 1Internet Information Servicessq_yzkdfcw027006000672013-05-08 01:15:52.530
RPC:Completedexec sp_cursoroption 180150001, 3, 2Internet Information Servicessq_yzkdfcw00006000672013-05-08 01:15:52.530
RPC:Completedexec sp_cursor 180150001, 40, 1Internet Information Servicessq_yzkdfcw030006000672013-05-08 01:15:52.530
RPC:Completedexec sp_cursor 180150001, 40, 1Internet Information Servicessq_yzkdfcw030006000672013-05-08 01:15:52.530
RPC:Completedexec sp_cursor 180150001, 40, 1Internet Information Servicessq_yzkdfcw030006000672013-05-08 01:15:52.530
RPC:Completedexec sp_cursor 180150001, 40, 1Internet Information Servicessq_yzkdfcw030006000672013-05-08 01:15:52.530
RPC:Completedexec sp_cursor 180150001, 40, 1Internet Information Servicessq_yzkdfcw030006000672013-05-08 01:15:52.530
RPC:Completedexec sp_cursor 180150001, 40, 1Internet Information Servicessq_yzkdfcw030006000672013-05-08 01:15:52.530
RPC:Completedexec sp_cursor 180150001, 40, 1Internet Information Servicessq_yzkdfcw030006000672013-05-08 01:15:52.530
RPC:Completedexec sp_cursoroption 180150001, 1, 0Internet Information Servicessq_yzkdfcw00006000672013-05-08 01:15:52.530
RPC:Completedexec sp_cursorfetch 180150001, 16, 743, 1Internet Information Servicessq_yzkdfcw0270166000672013-05-08 01:15:52.530
RPC:Completedexec sp_cursoroption 180150001, 3, 2Internet Information Servicessq_yzkdfcw00006000672013-05-08 01:15:52.547
RPC:Completedexec sp_cursor 180150001, 40, 1Internet Information Servicessq_yzkdfcw030006000672013-05-08 01:15:52.547
RPC:Completedexec sp_cursor 180150001, 40, 1Internet Information Servicessq_yzkdfcw030006000672013-05-08 01:15:52.547
RPC:Completedexec sp_cursor 180150001, 40, 1Internet Information Servicessq_yzkdfcw030006000672013-05-08 01:15:52.547
RPC:Completedexec sp_cursor 180150001, 40, 1Internet Information Servicessq_yzkdfcw030006000672013-05-08 01:15:52.547
exec sp_cursor 180150001, 40, 1 为什么会频繁执行呢？
[解决办法]
大量的游标。。若能改写程序，是最佳改善方法
若不能改写程序，得看数据库结构是如何的。。应该是有优化的空间
[解决办法]
sp_cursor 这个是你们自己写的吗？貌似没有这个系统存储过程
[解决办法]
