Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
narengk
Starting Member
7 Posts |
 Posted - 2008-04-17 : 03:30:00
|
| I use SQL2005 EE to capture the "In Progress Data" from the Devices and have connected it to the Main server-SQL2005 SE thro linked Server. I Run a Job that updates the Main server and Clears the "in Process Data".Off late I have been seeing that the systems with SQL2005 EE have gone slow ? I have not investigated the reason. But wanted to find out if using this method ,should I need to take additional precautions ? |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-04-17 : 05:37:46
|
| SQL2005 EE is express edition or enterprise edition?so your SQL2005 EE's that collect the data are getting slow?to help you resolve this we'll need more information about how you're collecting data and what part is getting slow exactly?_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
 |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2008-04-17 : 05:52:22
|
| Frequent inserts/deletes will cause fragmentation. You should scedule an index rebuild/reorganize to run regularly to minimize this problem.--Lumbago |
|
|
|
narengk
Starting Member
7 Posts |
Posted - 2008-04-17 : 06:47:41
|
| EE is Express Edition Sorry for the Confusion , I collect data thro a Windows (Mobile) application. The Reason to use such a system is to ensure that the Windows Application is not network dependent and works independently even when the network is disconneted. While the data on devices are needed for local processing, The data in the server(2005-SE) is mainly for analysis and archieving. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-17 : 22:58:28
|
| Do you update statistics regularly? |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-04-18 : 01:51:37
|
| Run a DBCC SHOWCONTIG on the relevant tables and investigate fragmentation issuesJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
Ola Hallengren
Starting Member
33 Posts |
Posted - 2008-04-18 : 05:07:57
|
| In SQL Server 2005 you can use the DVM sys.dm_db_index_physical_stats to check the index fragmentation. You can then use this information to decide if you need to do a rebuild, a reorganize or if it is good as it is.I have a stored procedure that can help you with this.http://ola.hallengren.com/sql-server-index-and-statistics-maintenance.htmlOla Hallengrenhttp://ola.hallengren.com |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2012-03-05 : 09:02:33
|
| It is REALLY annoying that you are reediting old scripts to push your scripts. Editing the posts is causing them to be treated as "changed" and thus they are coming up in the Active posts list and I expect all of us are opening the thread only to find it is 4 year old.If the link you had originally is wrong use a 301 redirect, or set up something in your URL Rewriter, to guide folk to the more appropriate location on your server please. |
|
|
|
|
|
|
Is there Performance Loss if I delete frequently