There are multiple ways to report errors from stored procedures. One way it so set the return code, which is always of type INT. The number can mean whatever you...

kennethigiri (3/15/2012)

---

Thanks very much people. Just that from some people's posts on the Internet I was beginning to get the impression that I should see this value reflected in the...

kennethigiri (3/15/2012)

---

Thanks very much people. Just that from some people's posts on the Internet I was beginning to get the impression that I should see this value reflected in the...

I think you're are OK in terms of the DB engine. SQL Server is reporting the memory as I would expect, noted by the 9.77GB figure for buffer_pool_target_memory_in_GB.

It's possible that...

Good call on the async stats, Jeff.

@paul-2, notice in my code sample the "USE [test]" immediately after the RESTORE and before we set it to SINGLE_USER. In essence this guarantees...

The batch size comes into play when loading the data into the database which is downstream from the issue I am highlighting.

The SqlBulkCopy.WriteToServer method (4 overloads) is how the class...

1. What is in your boot.ini? i.e. are you using the /PAE or /3GB switches?

2. Please post the results of this query run on your system:

SELECT CAST(physical_memory_in_bytes / (1024.0...

It does sound like a good plan. Without LPIM in place I suspect you will not be protected from the memory trims Windows imposes on SQL Server at times...one of...

No evidence of helping or hurting in terms of making more memory avaialble. But it...

What were the min/max_mem settings when taking the readings?

snomad (3/14/2012)

---

Thanks for your time, we do have the default trace enabled. But, unless I'm missing something which is quite probable, I can't see that the relevant SQL is...

Elliott Whitlow (3/14/2012)

---

Not easily.. The package...

True, but you can guarantee you are the anyone 😀

Unless you have a trace running capturing all SQL, you cannot. But, you may be able to tell who was running the process that caused the autogrows. If teh Default...

+1

Here...