I ran a profiler today and found that one of my stored procedures is taking a very high CPU read (1899999) and duration (3233333).
我今天运行了一个分析器,发现我的一个存储过程正在进行非常高的CPU读取(1899999)和持续时间(3233333)。
How can I fix this problem?
我该如何解决这个问题?
1 个解决方案
#1
You could start by showing us the contents of your stored procedure...Otherwise a generic answer like "Check to see what operations are being performed and optimise accordingly" will have to do.
您可以首先向我们展示存储过程的内容......否则,必须执行“检查以查看正在执行的操作并进行相应优化”等通用答案。
#1
You could start by showing us the contents of your stored procedure...Otherwise a generic answer like "Check to see what operations are being performed and optimise accordingly" will have to do.
您可以首先向我们展示存储过程的内容......否则,必须执行“检查以查看正在执行的操作并进行相应优化”等通用答案。