Thank you for script.

But it's need to SqlServer 2012 because of lag function.

why not just split & count?

CREATE FUNCTION dbo.kg_ifn_StrToTable

(

@List NVARCHAR(MAX),

...

david.wright-948385 (3/12/2013)

---

ercument_eskar (3/12/2013)

---

david.wright-948385 (3/12/2013)

---

Just a few tweaks (repeat quotes in strings, handle non-default instance name) and it works well on 2008R2. A few changes to dmv field names and it...

david.wright-948385 (3/12/2013)

---

Just a few tweaks (repeat quotes in strings, handle non-default instance name) and it works well on 2008R2. A few changes to dmv field names and it works on...

Hi David, i tried too, but when i execute

exec master.[dbo].[InstanceAnalysis_PerformanceBaseLine]

Msg 16924, Level 16, State 1, Procedure InstanceAnalysis_PerformanceBaseLine, Line 3679

Cursorfetch: INTO listesinde bildirilen degiskenlerin sayisi, seçilen sütunlarla uyusmalidir. (Turkish :-)...