Activity overview
Latest activity by duli
I'd like to piggy back on this thread. My SSMS crashes after a while because it ends up using about 3GB of ram and becomes unstable. The culprit is SQL Source control. To prove this I opened 2 sessions of SSMS (sql source control does not start automatically). One of them I opened source control, the second I did not. The second I have about 18 query tabs opened with results and consumes roughly 500MB. The second has always had only 2 tabs opened. One is sql source control and the other is sp_whoisactive (very similar to sp_who2 active). The one with source control is now at 1500MB and growing (it started at around 200MB I think). So something in your application is causing a memory leak or caching a ton of results. Redgate, in your post above you ask how many servers you connect to. Why does it matter if only 1DB in 1 server is connected to source control? are you reading the contents of every single DB that is in a server regardless of what's in source control?? Just an FYI, I only connect to 1 server but it has 5 databases - only 1 of which is connected to SQL source control. Very annoying. I have to go with this 2 SSMS approach now, and work only on 1, and use the other for source control since the one with source control is guaranteed to crash eventually. / comments
I'd like to piggy back on this thread. My SSMS crashes after a while because it ends up using about 3GB of ram and becomes unstable. The culprit is SQL Source control. To prove this I opened 2 sess...
Get deployment script
I've got several changes that I'm checking into Git, and I know that this generates a bunch of scripts for indexes etc that have been changed. How can I get access to this script? What I want to ge...