I do not know of a way to easily measure throughout at the table-level.

One way that comes to mind, albeit an extremely labor-intensive way, would be to move a table...

Can you clarify what you mean by "for all tables"?

Did you mean data throughput as in the amount of data read or written per second, or are you talking...

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 😀