curious_sqldba (3/7/2014)

---

I don't have any query hints being used, at server level i have MAXDOP = 5 and CTP = 1, in the exec plan i see that query is...

Yeah, Got it. Also could you check the Lock Mode (Update or Exclusive) and the type of lock acquired (granularity) ( RID,Page or Table) and the Isolation Level ?

--

SQLBuddy

Did you check what was the Lock Mode and the type of lock acquired (granularity) ?

--

SQLBuddy

Use this script and the results will match ..

SELECT

db_name() AS DbName,

SCHEMA_NAME(B.schema_id) AS SchemaName

, B.name AS TableName

, C.name AS IndexName

, A.INDEX_DEPTH as Index_depth

, C.fill_factor AS IndexFillFactor

, D.rows...

Yeah, just wanted to confirm from his end ..

--

SQLBuddy

muthyala_51 (3/7/2014)

---

My assumption is the accumulation of memory by sql server was at a slower pace than the memory required for the queries to run on the server at that...

muthyala_51 (3/7/2014)

---

The sql services got restarted by itself. It didn't failed over to other node. The services got restarted on the same instance. We tried to run the dbcc freebuffercache...

If you are heavily using SQL Server features that are discontinued in SQL 2012 and if it involves huge effort to replace those functionalities then that would be a business...

You are welcome pharmkittie 🙂

--

SQLBuddy

Koen Verbeeck (3/7/2014)

---

It is possible:

* store the current file name in a variable (you can configure this in the for each loop)

* inspect the file name with a script task....

Physical Memory is the RAM that you add to the Server. Yeah Virtual Memory is the Paging file. It's an area on the hard disk that Windows treats as if...

Looks good and nice implementation. But still we are starting the jobs in a sequential order not parallelly. This approach works as there is very minute lag between the...

CTP is Community Technology Preview. You can install it but it's not the final version and things may be modified before releasing the final version ( RTM). Since...

But, updating every statistic in the system doesn't identify the bottleneck. I mean, I wouldn't be at all shocked if they don't manually update statistics, few people do and they...

The quick and dirty way to find the bottleneck is sit down and pulse sys.sysprocesses filtered on the database while watching PerfMon and Task Manager - Performance and watch for...