Red Gate forums :: View topic - SQL Server 2005 Processes SLOOOOW
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Source Control 1
SQL Source Control 1 forum

SQL Server 2005 Processes SLOOOOW

Search in SQL Source Control 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
sspratlen



Joined: 16 Jul 2010
Posts: 1

PostPosted: Fri Jul 16, 2010 3:04 pm    Post subject: SQL Server 2005 Processes SLOOOOW Reply with quote

We just implemented using SQL Source Control 1.0.1.13 on our SQL 2005 Servers. Most of our DB's use 2000 Compatability.

We found that alot of processes are running from Red Gate doing multiple drops and select constantly, causing massive slow downs.

If we close SQL Studio and restart everything is fine for a short time, then it starts running drops and select again, utilizing large chunks of CPU time.

I am seeing these in sp_who2 active to verify that it is the Red Gate processes.

Any ideas? I really like the source control functionality, but I would hate to uninstall because I cannot have it slow other processes down to a crawl.

Thanks,
Scott
Back to top
View user's profile Send private message
sherr



Joined: 19 Mar 2009
Posts: 125
Location: Cambridge

PostPosted: Tue Jul 20, 2010 8:46 pm    Post subject: SQL Server 2005 Processes SLOOOOW Reply with quote

Hello Scott,

Our internal reference number is SOC-1334. We will follow up with you directly via email to get some more information about your system and try to work through this issue.

Thank you!
Stephanie M. Herr Smile
SQL Source Control Project Manager
Back to top
View user's profile Send private message
BjarneC



Joined: 12 Aug 2010
Posts: 1
Location: Denmark

PostPosted: Thu Aug 12, 2010 12:45 pm    Post subject: Reply with quote

Did you find any solution for this, as I am currently expiriencing similar behaviour ?
_________________
/Bjarne
Back to top
View user's profile Send private message
mamueller



Joined: 31 Aug 2010
Posts: 1

PostPosted: Thu Sep 02, 2010 11:31 am    Post subject: Reply with quote

Hello!

Is there any news about this issue?

Started using the tool as well, but are also experiencing the DB Load issue, which causes problems in our Dev Environment.

We´re using a Shared Dev DB, maybe thats the issue ?

thx
cheers
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 755
Location: Red Gate Software Ltd.

PostPosted: Mon Dec 06, 2010 9:14 pm    Post subject: Reply with quote

Sorry for the slow reply.

We're still looking into performance improvments for SQL Source Control, but I can give you a workaround which might help you in the mean time.

The workaround is to disable the code that polls your database. This will mean that the blue indicators in the Object Explorer are often out of date, but it should reduce the load on your database server to acceptable levels.

To apply the workaround, you will need to edit the 'RedGate_SQLSourceControl_Engine_EngineOptions' in your SQL Source Control configuration directory. This is either: C:\Users\<username>\AppData\Local\Red Gate\SQL Source Control 1 or C:\Documents and Settings\<username>\Local Settings\Application Data\Red Gate\SQL Source Control 1 depending on your operating system version.

The following XML is an example of setting the polling frequency to '0'. This will mean that SQL Source control will not check for changes, but you can still manually perform the check if you hit 'refresh'. You might want to try different values between 0 and the defaults, until you have an acceptable performance.

Code:
<?xml version="1.0" encoding="utf-16" standalone="yes"?><!----><EngineOptions version="2" type="EngineOptions"><DefaultTraceMinimumInterQueryTimeInMillis>0</DefaultTraceMinimumInterQueryTimeInMillis><SysObjectsMinimumInterQueryTimeInMillis>0</SysObjectsMinimumInterQueryTimeInMillis><SysTypesMinimumInterQueryTimeInMillis>0</SysTypesMinimumInterQueryTimeInMillis><DefaultTraceMinimumRequestedInterQueryTimeInMillis>0</DefaultTraceMinimumRequestedInterQueryTimeInMillis></EngineOptions>


THE v1 DEFAULT VALUES ARE:
25000 DefaultTraceMinimumInterQueryTimeInMillis
2500 SysObjectsMinimumInterQueryTimeInMillis
3500 SysTypesMinimumInterQueryTimeInMillis
5000 DefaultTraceMinimumRequestedInterQueryTimeInMillis

I hope this helps.
_________________
Chris
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group