BIDS: Development on your laptop or desktop has a limit

Close-programs-to-prevent-information-loss-low-on-memory

The execution results confirmed my first thought πŸ™‚

Close-programs-to-prevent-information-loss-BIDS-error

When I looked at the Resource Monitor, it seems that sqlserver.exe is eating up my memory…bad dog!
So…don’t forget to set a limit on memory usage for SQL Server on your laptop or desktop πŸ™‚

Advertisements

2 thoughts on “BIDS: Development on your laptop or desktop has a limit

  1. On my systems I never give SQL Server all server memory. I always leave 2 GB for OS and other processes. Consider reserving even less if you have frequent large SSIS or SSAS workloads running on the same server.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s