If you look at the code behind the view INFORMATION_SCHEMA.COLUMNS, it is looking at USER objects only:

CREATE VIEW INFORMATION_SCHEMA.COLUMNS
AS
SELECT
DB_NAME()AS TABLE_CATALOG,
SCHEMA_NAME(o.schema_id)AS TABLE_SCHEMA,
o.nameAS TABLE_NAME,
c.nameAS COLUMN_NAME,
COLUMNPROPERTY(c.object_id, c.name, 'ordinal')AS ORDINAL_POSITION,
convert(nvarchar(4000),
OBJECT_DEFINITION(c.default_object_id))AS COLUMN_DEFAULT,
convert(varchar(3),...

How is the page file utilization while CPU is spiking like that?  If page file utilization is starting to climb while the CPU is spiking, it might indicate something is...

I could be mistaken, but I thought all of the xp_ stored procedures were deprecated?

Not sure if this is relevant or not, but:

http://tomaslind.net/2014/01/28/alternative-xp_fixeddrives/

relevant section:

SELECT DISTINCT
  ...

• This reply was modified 5 years, 4 months ago by Mr. Brian Gale.

Both of those questions should be new posts as they are unrelated to the original post.  Replying to an old post with an unrelated question is not likely to get...

For those curious, in Windows you can still use xp_cmdshell and run fsutil volume diskfree <driveletter> where "<driveletter>" is the drive letter name such as "fsutil volume diskfree C:".

a lot...

As you have access to the server, what happens if you run the TSQL indicated in the second INFO message you posted above:

BACKUP DATABASE [Tfs_DefaultCollection] TO DISK...

My first thought on this is that the one SSAS cube is different than the others which is apparent to me since it uses all the CPU.  Now, the code...

Can you log into the server via SSMS?  If so, I would try running the backup command in the INFO message manually and see what error you get back.

If you...

I do not have SQL Server running on linux, but I think there may be better tools to report that data than SQL.  Things like Cacti, which is designed for...

I think this depends on what tool you are using to generate the data and what tool you are using to pull it into the database and what data you...

anything in the "users" folder is for a user account.  so those 3 folders are user accounts you have or had on your system at some point.

If I remember right...

Something to note - adding all of the recommended indexes isn't always going to be great for performance.

On a highly OLAP environment, automatic index tuning doesn't sound too bad.  On...

Hopefully it isn't corruption, but if it isn't, then I'd be checking other things like the antivirus to make sure it is not scanning the database files.

Might not hurt (if...

Nice.  It does sound like a useful tool for sure.

If I was connecting to a business critical server, I'd want to do some analytics on the tool to make sure...

Mike01, I think what Michael L John is looking for is what filters to put in place to strip out some of that "junk" data.

A quick look at what he...