Viewing 15 posts - 20,851 through 20,865 (of 49,552 total)
What's the exact command you ran to restore them?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 21, 2012 at 8:28 am
Don't understand your question.
As for the hit ratio, it's the % of times that SQL can find a cached plan. If it's lower, like after a free proc cache, if...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 21, 2012 at 4:32 am
Why is a high plan cache hit ratio a problem? That's the % of time that SQL finds a plan in cache when it looks for one.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 21, 2012 at 3:35 am
What's the state of the database (state_desc in sys.databases) and what messages are in the error log for this DB?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 21, 2012 at 3:34 am
On my server, session 30 is a service broker task.
I'm no service broker expert, but I suspect the problem with service broker (whatever it is) is causing this issue, not...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 21, 2012 at 3:32 am
Very weird... Are you using Service Broker at all?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 20, 2012 at 2:25 pm
All right, so 2 variable-length columns, 4 columns in total, one nullable
Record size:
tag bytes - 2 bytes
null bitmap offset - 2 bytes
fixed length columns - 9...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 20, 2012 at 2:24 pm
Interesting...
What's the Last_wait_type for those two system sessions? (16 and 30)? Same DMV.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 20, 2012 at 2:02 pm
If something was blocking the drop, then the session running the drop would not have a wait type of null, blocked by definition means waiting.
One last time...
What are the values...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 20, 2012 at 1:45 pm
Varchar what? Varchar(1)? Varchar(400)? Varchar(8000)? Varchar(Max)?
Varchar columns are variable length, so what's the average length of the data that will be stored in them?
Which columns are nullable?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 20, 2012 at 1:41 pm
WangcChiKaBastar (1/20/2012)
that doesnt tell me what command is running.
It tells you what the process is. So please, what is the command as shown in sys.dm_exec_requests?
Also, what is the wait type...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 20, 2012 at 1:26 pm
GSquared (1/20/2012)
Anyone else done that kind of thing?
Yup, but without the paid lunch. You'll be amazed how often the invited people (devs and DBAs) forgot about it.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 20, 2012 at 1:22 pm
Well, what's your table design? Can't help if you don't list the columns and data types.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 20, 2012 at 1:20 pm
Get that drive checked out, diagnosed and if necessary replaced.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 20, 2012 at 12:57 pm
Session ids that low are system connections, not user connections. You couldn't have opened a transaction on one of those connections. Also, an open connection can't change spids, if previously...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 20, 2012 at 12:56 pm
Viewing 15 posts - 20,851 through 20,865 (of 49,552 total)