Timeline for Queries that are usually fast running, sometimes take minutes?
Current License: CC BY-SA 3.0
16 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 28, 2015 at 10:46 | vote | accept | wezten | ||
| Jun 28, 2015 at 10:45 | answer | added | wezten | timeline score: 0 | |
| Jun 4, 2015 at 6:52 | comment | added | wezten | @AaronBertrand I appreciate the assistance you gave me | |
| Jun 3, 2015 at 21:35 | comment | added | wezten | @Kin maxmem:2147483647, maxdop:0. TF4199 was off. I tried increasing maxdop to 2, and switching TF4199 on, but it didn't help. | |
| Jun 3, 2015 at 21:17 | comment | added | Kin Shah | @wezten Why did you restart sql server ? that will trash all your plans + the setting is dynamic. What is the max memory , maxdop setting on the server ? Have you enabled TF 4199 ? | |
| Jun 3, 2015 at 21:04 | comment | added | wezten | @Kin I just changed it to 1 and restarted sql server, but it didn't help. | |
| Jun 3, 2015 at 20:53 | comment | added | Kin Shah |
is optimize for adhoc enabled (set to 1) ?
|
|
| Jun 3, 2015 at 20:52 | comment | added | wezten | @AaronBertrand added to the question. | |
| Jun 3, 2015 at 20:51 | history | edited | wezten | CC BY-SA 3.0 |
added 12285 characters in body
|
| Jun 3, 2015 at 20:45 | comment | added | Aaron Bertrand | Can you show the query that EF is submitting? | |
| Jun 3, 2015 at 20:42 | comment | added | wezten | @AaronBertrand On all the results of sys.dm_exec_requests blocking_session_id is 0. Besides for those with a status of 'background' and 'sleeping', there are 2 'running' ones and for both the wait_type is null. | |
| Jun 3, 2015 at 20:38 | comment | added | Aaron Bertrand | That doesn't mean there isn't blocking. When the query is running slow, check sys.dm_exec_requests -> wait_type and blocking_session_id. Retrieval of metadata is not really anything you can do anything about - it's usually fast unless there is some sort of Sch-* locking. | |
| Jun 3, 2015 at 20:38 | comment | added | wezten | @AaronBertrand Yes, by running sp_who2. | |
| Jun 3, 2015 at 20:27 | comment | added | Aaron Bertrand | Did you check for blocking? | |
| Jun 3, 2015 at 20:27 | review | First posts | |||
| Jun 3, 2015 at 22:01 | |||||
| Jun 3, 2015 at 20:23 | history | asked | wezten | CC BY-SA 3.0 |