something is misconfigured - SQL Server Forums

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.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

something is misconfigured

Author

Topic

WJHamel
Aged Yak Warrior

651 Posts

Posted - 2012-02-17 : 10:43:01

given my system specs and configuration, i should not be running out of memory when only trying to copy a table with 240,000 rows to the clipboard. Nonetheless, i am, even immediately after a reboot with minimal memory resident junk running. Therefore, i declare shenanigans and assume something is less than optimally configured with my instance of sql server (2008R2). I've copied what i "think" is the relevant portion of a belarc report and can answer any other questions one might pose, but overcoming this issue would be grand.

Windows 7 Enterprise (x64) Service Pack 1 (build 7601)
Install Language: English (United States)
System Locale: English (United States)
Installed: 12/14/2011 12:42:03 PM Dell Inc. OptiPlex 990 01
System Service Tag: FT1MZQ1 (support for this PC)
Chassis Serial Number: FT1MZQ1
Enclosure Type: Space-saving
Processor a Main Circuit Board b
3.40 gigahertz Intel Core i7-2600
256 kilobyte primary memory cache
1024 kilobyte secondary memory cache
8192 kilobyte tertiary memory cache
64-bit ready
Multi-core (4 total)
Hyper-threaded (8 total) Board: Dell Inc. 0D6H9T A00
Serial Number: /FT1MZQ1/CN7360415D042O/
Bus Clock: 100 megahertz
8074 Megabytes Usable Installed Memory
SQL:
Microsoft SQL Server Management Studio 10.50.1600.1
Microsoft Analysis Services Client Tools 10.50.1600.1
Microsoft Data Access Components (MDAC) 6.1.7601.17514
Microsoft MSXML 3.0 4.0 6.0
Microsoft Internet Explorer 9.0.8112.16421
Microsoft .NET Framework 2.0.50727.5448
Operating System 6.1.7601

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2012-02-17 : 15:12:34

What's your max memory setting in SQL Server? I'd set it to about 6 GB.

What else is running on this box?

WJHamel
Aged Yak Warrior

651 Posts

Posted - 2012-02-17 : 15:44:31

max mem is set to 2147483647. The only other apps running are sql assistant, redgate, and msoffice 2010 suite as well as office communicator. My available physical memory is typically between 3000 and 3500 while my free memory is between 1000 and 1300.

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2012-02-17 : 16:17:50

Set the max memeory to 3 GB. Maybe 2.5.

Tweak from there if SQL needs more.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources