Too sp_columns in activity of SQL Server

15 replies
2003 views
Translate

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 is closed to new replies. Start a new post to keep the conversation going.

BKBK

Community Expert

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

Translate

X

xfreeman89xAuthor

Inspiring

Coldfusion 9 with latest update

Translate

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,

^_^

Translate

X

xfreeman89xAuthor

Inspiring

Hi Wolf,

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

What are you thinking about this problem?

Translate

Salvatore Cerruto

H

haxtbh

Inspiring

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

Translate

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?

Translate