Viewing 15 posts - 42,166 through 42,180 (of 49,552 total)
I can't see any indications of poor IO performance from those stats.
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
December 22, 2008 at 2:32 pm
DBASkippack (12/22/2008)
We inadvertantly had 6 DB's DROPPED from a non-prod environment. How can I tell who (or what process) dropped them?
If you didn't have some trace running at 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
December 22, 2008 at 2:31 pm
Why are you using a cursor at all? The update doesn't reference the cursor row, meaning you're doing exactly the same update multiple times.
The two inserts can be done...
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
December 22, 2008 at 2:27 pm
HKwai (12/22/2008)
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
December 22, 2008 at 9:32 am
John (12/22/2008)
I was wondering if some form of a detach / re-attach would work from the other log shipped standby server at C.
Unfortunately not.
If you try to detach an...
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
December 22, 2008 at 9:28 am
Michael Earl (12/22/2008)
Don't bite my head off Gail,
Not biting anything
just wanted to make the point that it is logged "differently" without typing out a lot of detail.
Sorry, it's just...
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
December 22, 2008 at 9:09 am
Perry Whittle (12/22/2008)
Ahmad Osama (12/22/2008)sqlcmd -S BUILDSERVER -E
is BUILDSERVER the correct instance name?
It's the servername of the server that he's starting in single user mode. Check the attached error log...
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
December 22, 2008 at 8:42 am
Ok. Confirm the following for me.
1) You have stopped the service.
2) You have one command window open where you ran sqlservr -m and then left it running
3) You are running...
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
December 22, 2008 at 8:38 am
Michael Earl (12/22/2008)
TRUNCATE is a non-logged operation, so if you are using log shipping or have regular log backups running, it can cause you some issues.
Not at all.
Truncate table...
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
December 22, 2008 at 8:37 am
HKwai (12/17/2008)
Does anyone know of a solution to this?
EXECUTE AS
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
December 22, 2008 at 8:33 am
Peso (12/22/2008)
Doesn'tIF UPDATE(colStatus)
do that for you?
That just checks if the column was referenced in the update statement. If the column is updated to itself, UPDATED will be true...
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
December 22, 2008 at 8:28 am
subha.v (12/22/2008)
Advanced thaks for all.I didn't expect this much reply from my post. It's really helpful for me to know more about the problem.
If you answered all the questions we've...
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
December 22, 2008 at 8:23 am
Perry Whittle (12/22/2008)
are you sure
NET STOP MSSQLSERVER
is stopping the correct instance?
It's the same instance that he's starting and the same one he's connecting to via sqlcmd. Whether it's...
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
December 22, 2008 at 8:20 am
Paul (12/22/2008)
From what I've read, there's an overhead associated with checking for locks that you incur even if there aren't any.Adding NOLOCKS is supposed to skip that.
Very small overhead.
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
December 22, 2008 at 6:32 am
subha.v (12/22/2008)
Sorry. I am waiting for my PL approval.
?
Could you please confirm is searching based on the non-clustered index cause the performance problem.
No. Not enough information.
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
December 22, 2008 at 6:16 am
Viewing 15 posts - 42,166 through 42,180 (of 49,552 total)