Too sp_columns in activity of SQL Server

Forum|Forum|9 years ago
July 7, 2016
4 replies
1959 views

Hi all,

I started profiler in my SQL Server 2008 R2 and I see a lot of calls to sp_columns. This is a procedure that retrieve table informations. I guess that ColdFusion is calling this function when I execute cfquery. Is there any way to reduce this overload?

Thanks!!!

This topic has been closed for replies.

BKBK

Community Expert

Could it just be that SQL Server executes the procedure sp_columns when you run the profiler?

X

xfreeman89xAuthor

Inspiring

Coldfusion 9 with latest update

Salvatore Cerruto

WolfShade

Legend

Which of the following examples represents a majority of the SQL contained within your queries?

SELECT userID, userName, lastLogin FROM tableUsers

SELECT * FROM tableUsers

V/r,

^_^

X

xfreeman89xAuthor

Inspiring

Hi Wolf,

the first example, I'd say, but it continue with where clause.

What are you thinking about this problem?

Salvatore Cerruto

H

haxtbh

Inspiring

I assume the table names it is using to lookup are names you are familiar with? Those tables exist?

H

haxtbh

Inspiring

What makes you think it is Coldfusion? The call to sp_columns will only appear if something is calling it , and Coldfusion wont do this without someone writing code to specifically call it.

How often is it happening and why do you think its overloading things?