Slow performance vs2012.1

Ingeniously simple database development in Visual Studio

Slow performance vs2012.1

Postby coffeehouse » Wed Feb 13, 2013 2:43 am

Hello and thanks for the great tools!

I wanted to give some feedback and/or see if i am not alone in this.

I have a rather large db of 20k+ objects (tables, views, sp's, function's,schema's, etc..)

When i have this in my solution, scrolling the list of tables, views, proc's etc, its so slow that its not even worth scrolling. In fact the only way i can use it, is utilizing the search box in the solution explorer.

Is this whats expected? I didn't think the scrolling would be such drain and its not for the SQL Server Database Projects i have in the now.

Spec for my comp:
i5-2500k 3.3ghz
8gb ddr3 1600 ram
hard disk - sandisk ssd 240gb.
gigabyte motherboard.

Its a screamer and my large solutions load in about 15 secs, so the performance hit i seen was not expected, but maybe its something i did? or is this expected?

Thanks again!
Posts: 1
Joined: Wed Feb 13, 2013 2:32 am

Postby eddie davis » Mon Feb 18, 2013 11:40 am

Hi Coffeehouse,

Thank you for your forum post and sorry for the late reply.

A support call has been created for you, call reference F0069618

Can you please locate the SQL Connect log files normally available in this folder, C:\\Users\\<user_name>\\AppData\\Local\\Red Gate\\Logs\\SQL Connect 1, and send an e-mail to, include the above call reference number in the subject field of the e-mail and attach the log file or files to the e-mail message?

I have looked through previous support calls, thus far you appear to be the first user to reported this type of error.

Many Thanks
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
eddie davis
Posts: 1147
Joined: Wed Jun 14, 2006 2:47 pm
Location: Red Gate Software

Postby thomashess » Mon Mar 24, 2014 11:11 am

I am experiencing the exact same thing. Is there a solution for this?

Just installed SQL Connect to evaluate it, and I have around 1700 objects (tables + sprocs).

Scrolling is impossible. I can click somewhere in the scroll bar and it takes around 5-10 seconds for the list to move down around 10 items.

SQL Connect is totally useless unless this is resolved.

Running VS2013 with latest version of SQL Connect and SQL Source Control (downloaded from site today).

Best regards

P.S. let me know if you want log files. I am also a bit taken back by the fact that a lot of log files of 50 MB each are generated. See timestamps here:

SQL Connect 1-2014_03_24_09_52_50_0.log
SQL Connect 1-2014_03_24_11_37_08_0.log
SQL Connect 1-2014_03_24_11_41_18_0.log

50 MB of logging in just 4 minutes? That's insane... I can't imagine how much space that will take up if I start using this correctly. Perhaps it is the writing of log files that is slowing everything down?
Posts: 1
Joined: Mon Mar 24, 2014 11:09 am

Return to SQL Connect

Who is online

Users browsing this forum: No registered users and 0 guests