August 24, 2011 at 2:46 am
This morning in SSMS in the Activity Monitor I noticed the same script for all my users, does this effect performance and how did it come about? Any info will be appreciated!
(@_msparam_0 nvarchar(4000),@_msparam_1 nvarchar(4000),@_msparam_2 nvarchar(4000))SELECT
clmns.name AS [Name]
FROM
sys.tables AS tbl
INNER JOIN sys.all_columns AS clmns ON clmns.object_id=tbl.object_id
WHERE
(CAST(clmns.is_sparse AS bit)=@_msparam_0)and((tbl.name=@_msparam_1 and SCHEMA_NAME(tbl.schema_id)=@_msparam_2))
ORDER BY
clmns.column_id ASC
August 24, 2011 at 2:46 pm
Are all the users using SSMS? This looks like an Intellisense query.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 25, 2011 at 2:27 am
Well not all the users, some access the data warehouse via Access.
On another blog someone suggested possible corruption in a table and Im starting to think this was the case as one of ETL processes ran for hours until we killed it and reloaded back up data..then fine.
However with regards to Intellisense, I dont have much knowledge on the topic and believe it does exsist within MS SQL Server 2008 and the BIDS environment.
Thanks for your reply
August 25, 2011 at 6:41 am
travis.vandyk (8/25/2011)
Well not all the users, some access the data warehouse via Access.On another blog someone suggested possible corruption in a table and Im starting to think this was the case as one of ETL processes ran for hours until we killed it and reloaded back up data..then fine.
Could you post the link to the blog post? I'm not sure why a corruption issue would cause every client to issue a specific query. It doesn't make sense to me.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 25, 2011 at 7:06 am
sorry it was another forum: His reply
"Sounds like a corrupt system table in some database(s). Run DB check!
You also didn't mention if they were succeeding or stuck so i would assume they were waiting for something... maybe for IO of the DB file -- then again i suppose such system tables would be kept in memory anyway assuming it had been accessed even once... "
August 25, 2011 at 7:23 am
Can you post a link to the forum? I'd like a more in depth explanation and if I go there I can ask.
Thanks
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply