June 10, 2014 at 10:57 am
I've got an issue with tempdb on one of the servers. When I try to access properties in SSMS, I get the following message:
Property Size is not available for Database '[tempdb]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights.
Trying to expand any of the folders within SSMS tempdb results in timeout with the following error:
Lock request time out period exceeded. (Microsoft SQL Server, Error: 1222)
Does anyone have any idea on how to troubleshoot this? There is nothing in the errorlog, and last time this happened, a SQL Service restart took care of this issue. I'd like to actually get to the core of the problem, so we could possibly change something to avoid this issue in the future.
June 10, 2014 at 11:16 am
What do you get when you run sp_helpdb 'tempdb' ? Is this a Cluster?
June 11, 2014 at 11:44 am
what credentials are you using on this SQL Server ? are you in the 'sysadmin' role ?
is the server really busy ?
have you tried running the query from SQLCMD ?
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply