英文:
Simple query is very slow which was working fine before
问题
我的SQL Server（使用ASP.NET和C＃，甚至使用SSMS）突然变得非常慢。之前它一直正常工作。
例如，在SSMS中，这个简单的查询需要14秒
SELECT COUNT(*)
FROM AllAppointments
表“AllAppointments”具有非常简单的结构，包含7列，只有大约55,000行。这个查询在SSMS中以前几乎不需要时间，现在需要14秒。
可能的原因是什么？如何找到问题并如何修复？
英文:
My SQL Server (using ASP.NET and C#, or even using SSMS) is very slow all of a sudden. It was working fine before.
For example, this simple query (in SSMS) is taking 14 seconds
SELECT COUNT(*)
FROM AllAppointments
Table AllAppointments has a very simple structure with 7 columns, and only about 55'000 rows. This query was taking no time at all in SSMS and now it takes 14 seconds.
What can be the reason? How to find and how to fix?
答案1
得分: 0
针对访问此链接以寻找相同或类似问题的人。
这是对我的服务器上一个数据库的垃圾邮件机器人攻击，导致服务器变慢。一旦我解决了这个问题，一切都恢复正常。
英文:
For people coming to this link looking for same or similar issue.
It was a Spam Bot attack to one of the DB on my server which had slowed down the server. Once I fixed the issue everything got normal.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论