Viewing 15 posts - 22,846 through 22,860 (of 49,552 total)
And you can get info on the plans in cache from sys.dm_exec_cached_plans.
Exec_cached_plans - one row per plan in cache
Exec_query_stats - one row per statement in the batch/plan, so there will...
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
October 20, 2011 at 11:23 am
Ninja's_RGR'us (10/20/2011)
GilaMonster (10/20/2011)
Ninja's_RGR'us (10/20/2011)
Is there a time limit where I can get a new address? 😀
It's usually 6 months to a year depending on local laws. Otherwise I'd just take...
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
October 20, 2011 at 8:41 am
pavithrareddyc (10/20/2011)
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
October 20, 2011 at 8:35 am
Ninja's_RGR'us (10/20/2011)
Is there a time limit where I can get a new adress? 😀
It's usually 6 months to a year depending on local laws. Otherwise I'd just take a vacation...
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
October 20, 2011 at 8:30 am
Ninja's_RGR'us (10/20/2011)
GilaMonster (10/20/2011)
Grant Fritchey (10/20/2011)
Ian Massi (10/20/2011)
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
October 20, 2011 at 8:10 am
Grant Fritchey (10/20/2011)
Ian Massi (10/20/2011)
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
October 20, 2011 at 8:09 am
Don't understand the question. Are you looking for a script to calculate the size of a database?
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
October 20, 2011 at 8:07 am
Sorry, didn't notice the attachment.
That says very little. Latch waits are waits memory structures and without info on what memory structure (which, iirc SQL 2000 does not expose) it's going...
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
October 20, 2011 at 8:06 am
p.s. The reason those two states are distinct is because they have different causes and (often) different resolutions.
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
October 20, 2011 at 7:59 am
Exactly as the error says, you can't kill system processes and 7 is a system process.
What's it doing? Does it have a wait type?
What's session 56 doing? What's its wait...
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
October 20, 2011 at 7:47 am
Kwisatz78 (10/20/2011)
I10/20/2011 11:37:58,spid33s,Unknown,File activation failure. The physical file name "E:\Microsoft SQL Server\MSSQL10_50.SQL2008R2\MSSQL\DATA\ForEmergency_log.LDF" may be incorrect.
Yeah, that looks like recovery_pending, not suspect. So database inaccessible, won't have the (suspect) marker on...
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
October 20, 2011 at 7:41 am
Rather than databasepropertyex, query sys.databases. Check the status there.
My guess, it was recovery_pending. That looks like suspect to database property but won't put the (suspect) tag on the DB. The...
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
October 20, 2011 at 7:29 am
Just for your info, the reason your script was failing is that one or more databases, schemas or tables has a name that's either a reserved word or starts with...
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
October 20, 2011 at 7:26 am
NM
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
October 20, 2011 at 7:12 am
mark.castro (10/20/2011)
IF some could answer me this, or post a thread that may cover this, how can I move the instance from F drive to C
Uninstall. Reinstall.
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
October 20, 2011 at 6:42 am
Viewing 15 posts - 22,846 through 22,860 (of 49,552 total)