Sorry for not being so clear about the objective. We just want to measure the disk performance. I know this is a very crude and inaccurate means but right now...

Eddie Wuerch (5/18/2011)

---

For disk transfer rates, look at the DMF sys.dm_io_virtual_file_stats. The values are cumulative, so you need to sample it over a time range a diff the values.

As for...

I've been rummaging all the DMV's actually, for the 2 counters but I just couldn't find any equivalent. I just want to verify and confirm it from sql server savvy...

The description in the link answer my question. Silly me.

KEKline (4/25/2011)

---

You should get my free SQL Server PerfMon counters poster at http://www.quest.com/backstage/promotion.aspx. That URL is going to change soon, btw. I was really thrilled to hear that...

SQL Server spawns multiple aggregates at a time and that means some of them may have their Terminate called prematurely. You just need a null check for the items field...

I experienced similar quirks with design time values. The values I set in the variable pane were not the ones used in the execution. They were always changed to default...

Thanks for the reply Chris.

I made another package and still the same result. My question then is how shall I supply values to my variables during debugging?

Crispin I did exactly what you instructed. The weird thing is, only the User::vendorId contains a value of -1 (my init value) when I peek in the Locals and...

Thanks Crispin. Everything is green now. However, it seems like the value I set for the input parameters is not transferred to the parameter. I initialized the value of my...

I ran some tests again and I found out that even the hardcoded version IS NOT working at all. I was given the impression it worked because of the default...

Made this work per suggestion of an MS guy. The behavior is due to the fact that the owner of the database is not a local account that belongs to...

I did test the sproc both from the analyzer and vb. And I also found out in some articles that SET NOCOUNT OFF has adverse effects on performance. But it...

hi grasch

I think Steve asked if the value of the new identity column is generated in the select part of the insert into construct like this

insert...

Oooops. I think I was so agog to post then. I didn't read the original post carefully.

quote:

---

However odds are most queries...