so what can be used to see an accurate view of how much memory SQL is using?

if i add up all the processes on the server, with SQL showing...

well poop, you're right. i just tried an experiment on a test server and it just deleted the ndfs and restored into one big mdf again. i guess i gotta...

thanks! pushing out a registry update would be soooo much easier...

means i have to install the sql config utility on all client machines? not good... 🙁

Error with Query Analyzer: Unable to connect to server XXX_Test

Server: Msg 17, Level 16, State 1

[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied

(Not access denied, I'm admin...

awesome info .... thanks guys!

i just had a brainfart -

would it work the same if we simply:

1) stop SQL Server

2) copy ALL user and system databases to new SAN location

3) remove local...

sounds good. can you (or anyone) verify that this is correct?

1) detach all user databases and copy to new SAN location

2) add -c -m -T3608 in startup params and...

I get the same error sporadically when processing a virtual cube via DTS.

The error would happen about 2-3 times a year on our test system, never on production.

Now, after...

i guess the question is - why do you want to release this memory from SQL?  it will just have to grab it back when it needs it again. it isn't...

check your query. http://support.microsoft.com/kb/814889

SYMPTOMS

<script type=text/javascript>loadTOCNode(1, 'symptoms');</script>

64 or 32 bit SQL/Windows?

how much physical ram on the server?

what are the memory settings for SQL?  sql properties/memory - min/max, dynamic, fixed, etc.

after a restart, set up a profiler...

rule-of-thumb is to set up VM pagefile to be 1.5x that of physical ram. SQL will use VM as needed, let it do it's thing. don't worry about it. it's...

THat works!  Thanks, Deepak.

I'm surprised such a fundamental bug exists even at SP2 level. And that there aren't hundreds of posts already on this problem.

hi steve,

the processing log is missing info, which is part of the problem, since i have no clues on the actual cause of the failures. in the log, it will...