Viewing 15 posts - 17,686 through 17,700 (of 49,552 total)
SQLSACT (7/11/2012)
Hi AllA question regarding the following DMV:
sys.dm_os_wait_statsDoes this DMV indicate processes that are currently in a waiting state or processes that have had to wait for resources?
That is cumulative...
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
July 11, 2012 at 8:14 am
Sorry, sys.dm_exec_sessions (not requests). Shouldn't answer questions before 2nd cup of coffee.
That will show you other connections present, filter for is_user_session = 1 (or something like that, can't recall column...
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
July 11, 2012 at 8:06 am
p.s. If you decide to hack the system tables, post back and I'll walk you through step by step. It's too risky to have a go at if you aren't...
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
July 11, 2012 at 7:28 am
raotor (7/11/2012)
OK, I ran the query you kindly provided and it yielded no rows. This suggests that there are no other resources/connections using the database in question.
Now there aren't. Back...
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
July 11, 2012 at 7:16 am
yup (7/11/2012)
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
July 11, 2012 at 7:07 am
Option 1: Script all objects, export all data (bcp out or SSIS), recreate the database. Yes, it's a lot of work.
Option 2: hack some more at the system tables.
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
July 11, 2012 at 6:56 am
And, the checkDB output was???
That command doesn't fix anything, it checks for errors in the database.
As for sys.dm_exec_requests, any sessions from your login name other than the one you are...
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
July 11, 2012 at 3:31 am
yup (7/11/2012)
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
July 11, 2012 at 3:14 am
No, transaction count is of no interest here. All that's of interest is whether there are other connections (other rows) than yours.
That error sounds nasty.
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS,...
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
July 11, 2012 at 3:02 am
SELECT database_name ,
MAX(CASE type
WHEN 'D' THEN backup_finish_date
...
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
July 11, 2012 at 1:39 am
There's another connection, probably from SSMS (it often opens multiple connections).
Make sure object explorer is closed, that you are in the context of some other DB to run the alter...
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
July 11, 2012 at 1:34 am
Yes, you can attach screenshots.
DBCC UpdateUsage (shouldn't affect log files, but), and check what the size is in the OS please.
The 2TB is documented in BoL and the MSDN pages,...
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
July 11, 2012 at 1:22 am
Yup. Without a cluster, all nonclustered indexes get the RID (8 bytes). With a non-unique clustered index, the duplicate rows in the clustered index get a 4-byte uniquifier (yes, that...
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
July 10, 2012 at 4:12 pm
Good, just the one error.
Ok, two options for fixing this.
Option 1 will be a lot of work, take quite a bit of time, but safe
Option 2 will be quick to...
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
July 10, 2012 at 3:25 pm
Please run the following and post the full and complete results.
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
Yes, it's something you need to repair.
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
July 10, 2012 at 2:58 pm
Viewing 15 posts - 17,686 through 17,700 (of 49,552 total)