memory bottlenecks

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » memory bottlenecks

memory bottlenecks

Rate Topic

Display Mode

Topic Options

Author

Message

kapil112307

Posted Tuesday, May 25, 2010 7:27 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, June 18, 2010 2:07 PM
Points: 6, Visits: 16

I am trying to test memory bottlenecks for that i have to create memory bottlenecks.
Can anyone tell me to create them

Post #927447

TheSQLGuru

Posted Tuesday, May 25, 2010 8:59 AM

Hall of Fame

Group: General Forum Members
Last Login: Today @ 6:52 PM
Points: 3,582, Visits: 5,132

Set max sql server memory to a very low value and then run very large hash joins will hit one form of memory issue. But there are MANY different memory buckets and areas that can be considered as "memory bottlenecks".

Best,

Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru at GMail

Post #927547

kapil112307

Posted Tuesday, May 25, 2010 10:21 PM

Forum Newbie

Group: General Forum Members
Last Login: Friday, June 18, 2010 2:07 PM
Points: 6, Visits: 16

can you please deeply specify how can i can create
1)External physical memory pressure
2)External virtual memory pressure
3)internal physical memory pressure
4)internal virtual memory pressure

while surfing on net i found many links how to detect them but none referred how to create them

Post #927934

« Prev Topic | Next Topic »

Permissions