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.
| Author |
Topic |
|
darkdusky
Aged Yak Warrior
591 Posts |
 Posted - 2008-10-15 : 05:57:57
|
| Hi, I have an XML generating query which causes a Memory Exception error.The server is Windows Server 2003, 8 processors and 8GB RAM. I've added the /PAE and 3GB switches and increased both min and max server memory and query memory. If I run the query I get the memory error. Any suggestions? |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-10-15 : 06:00:04
|
| how big is the xml?_______________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.1 out! |
 |
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2008-10-15 : 06:12:16
|
| around 24 MB |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-10-15 : 06:32:36
|
| can you show us the exception?_______________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.1 out! |
|
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2008-10-15 : 06:50:57
|
| An error occurred while executing batch. Error message is: Exception of type 'System.OutOfMemoryException' was thrown. |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-10-15 : 07:32:18
|
| yes but where? in management studio did the error display in a dialog box or in the messages pane of the query window?_______________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.1 out! |
|
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2008-10-15 : 07:45:01
|
| In the messages pane. |
|
|
|
|
|
|
XML Memory error