Finding sources for CURSORS

• bediyev

  SSC Rookie

  Points: 32

  More actions

  October 28, 2019 at 12:07 pm

  #3692323

  Hello,

  I am new to SQL server administration. I use SQL server 2012. My background is a developer. Sometimes, when the process of the CPU usage goes so high, i open activity monitor and see something like this:

  FETCH API_CURSOR000000000001DC29 and the execution time is higher than 5000 and CPU is higher than 10000 on this thread. But i can't find  neither the query behind nor the session id of the user making this process.

  My question is, what can i do in these kind of situations?

  Thanks a lot for all reactions.

• frederico_fonseca

  SSCoach

  Points: 16272

  More actions

  October 28, 2019 at 12:56 pm

  #3692347

  you to know there is a thing called google don't you?

  from the thing above the following are 2 results

   

  https://www.sqlskills.com/blogs/joe/hunting-down-the-origins-of-fetch-api_cursor-and-sp_cursorfetch/

  https://blog.sqlauthority.com/2015/01/10/sql-server-what-is-the-query-used-in-sp_cursorfetch-and-fetch-api_cursor/

• MVDBA (Mike Vessey)

  SSC-Insane

  Points: 21797

  More actions

  October 28, 2019 at 1:26 pm

  #3692354

  Good question and frederico's links showed me some things that I hadn't had chance to look at yet.

  I'm guessing the application causing this is a Microsoft office (access/excel) app?

  MVDBA