SQLServer Express的速度很慢 [英] Slowness of SQLServer Express

问题描述

我正在使用SQL Server Express Edition。它包含10个数据库，每个数据库包含4GB以上的数据并且它会增长。有7个EXE'正在运行，它每5秒在每个数据库的4个表中插入多行。



我的问题是，当我同时运行所有EXE时，数据库处理速度变慢了。例如，我有EXE'，如E1，E2，E3，它分别在表D1，D2，D3中插入记录。其中一个表包含datetime列，它记录每5秒的当前日期和时间。在初始阶段，它记录正​​确的时间，但在5或10分钟后，它将数据排队并且进程变慢。也就是说，现在考虑时间是12:00，但列中记录的时间是11:45。当我运行单个EXE时，它会正确加载数据并记录当前时间。有没有可能避免这种缓慢？

I''m using SQL Server Express Edition.It includes 10 databases with each containing data above 4GB and it grows. There are 7 EXE''s running and it inserts multiple rows in 4 tables in each database for every 5 seconds.

My issue is, When I running all the EXE''s at the same time, the database processing is getting slowed down. For example, I have EXE''s like E1,E2,E3 and it inserts records in table D1,D2,D3 respectively. One of the table contains a "datetime" column and which records the current date and time for every 5 seconds. During the initial stage, it records the correct time, but after 5 or 10 minutes, it queues the data and process is getting slow down. that is, consider now the time is 12:00, but the the time recorded in the column is 11:45. When I run a single EXE, it load the data correctly and will record the current time. Is there any possibility to avoid this slowness?

推荐答案

如果您的EXE'在安装了SQL的同一个盒子上运行，那么最有可能共振是资源争用。



话虽如此，您可以考虑更改为SQL Server 2012 express，它可以帮助您使用localdb的新功能。现在，因为你有多个应用程序运行，我假设他们到轻量级应用程序，这个功能允许你有嵌入式数据库。看看并使用酷炫的功能。

If you have your EXE''s running on the same box where you have the SQL installed, then the most possible reson is resource contention.

Having said that, you can consider changing to SQL Server 2012 express which can help you with its new feature of localdb. Now, since you have mutiple application to run and I am assuming them to lighweight apps, this feature allows you to have embedded dbs. Take a look and make use of the cool feature.

请注意，SQL Server Express（2008 R @）支持1个CPU和1 GB或RAM。当您运行多个EXE时，我认为由于内存和CPU不足，性能会降低。

http://blogs.msdn.com/b/sqlexpress/archive /2010/04/21/database-size-limit-increased-to-10gb-in-sql-server-2008-r2-express.aspx [ ^ ]

但我相信可能还有其他原因，但无法从您的描述中找出答案。

Please be noted that, SQL Server Express (2008 R@) supports 1 CPU and 1 GB or RAM. As you are running multiple EXE so I think due to lack of memory and CPU, you are getting slower performance.
http://blogs.msdn.com/b/sqlexpress/archive/2010/04/21/database-size-limit-increased-to-10gb-in-sql-server-2008-r2-express.aspx[^]
But I believe there could be other reasons but it is not possible to figure out from your description.

这篇关于SQLServer Express的速度很慢的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！