Solved

tempdb property size is not available

Posted on 2015-02-16
7
387 Views
Last Modified: 2015-02-18
Hi,

I'm trying to look into the properties of my sql server's tempdb.  I keep getting this error (attached).  This is an online production system so it is under quite heavy load.

This is MS SQL 2012 SP2 running on Windows Server 2012 R2 in a cluster.
sqlerror.PNG
0
Comment
Question by:ts11
7 Comments
 
LVL 75

Expert Comment

by:Anthony Perkins
Comment Utility
Do you belong to the sysadmin server role?
What property are you trying to view?
0
 

Author Comment

by:ts11
Comment Utility
Yes I am.
I'm just trying to view the properties of the db using sql management studio.
0
 
LVL 14

Accepted Solution

by:
Vikas Garg earned 500 total points
Comment Utility
Hi,

This is due to some long running query which us using tempdb. so when the query running will finish this error will simply go.
If you want to find that query you can use the profiler while clicking on property for temp db if still that is not visible than  enabled the "User Error Message"
That will give you the query.
0
What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

 
LVL 26

Expert Comment

by:Zberteoc
Comment Utility
Run these queries see what you get:
SELECT * FROM fn_my_permissions(NULL, 'SERVER');
SELECT HAS_PERMS_BY_NAME(null, null, 'CONTROL SERVER');

Open in new window

first one will give you all permissions you have at server level abd the second one will return 1 if your current login has admin rights.
0
 
LVL 69

Expert Comment

by:ScottPletcher
Comment Utility
Don't use the GUI for those types of requests.  Instead, use:

EXEC tempdb.sys.sp_helpdb
0
 
LVL 75

Expert Comment

by:Anthony Perkins
Comment Utility
I'm just trying to view the properties of the db using sql management studio.
Can you be a tad more specific?  I mean what specific properties do you need?

Don't use the GUI for those types of requests.
Exactly, that is what I was trying to get at!
0
 

Author Closing Comment

by:ts11
Comment Utility
An open query still had a session open.
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

I don't know if many of you have made the great mistake of using the Cisco Thin Client model with the management software VXC. If you have then you are probably more then familiar with the incredibly clunky interface, the numerous work arounds, and …
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now