Viewing 15 posts - 44,821 through 44,835 (of 49,552 total)
What's in the waitresource column depends on the wait type. I'm going to guess that the wait is for a page latch/page io latch and that this resource is databaseID:FileID:...
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
August 27, 2008 at 2:26 am
There shouldn't really be any performance impact.
The main problems you're going to encounter is that you won't be able to use foreign keys (as they require a unique or...
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
August 27, 2008 at 2:15 am
Something within the loop (or someone else) must have changed the recovery model. SQL won't change recovery models on its own
Look for ALTER DATABASE statements within the code you're 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
August 27, 2008 at 1:52 am
Can you save the exec plan as a .sqlplan file, zip it and attach it? That will help a bit.
Otherwise, you can check and see if the indexes are being...
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
August 27, 2008 at 1:50 am
To expand a bit, they are orphaned distributed transactions. What happens is that some app uses DTC in it's communications with SQL and then doesn't properly commit or rollback 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
August 27, 2008 at 1:48 am
bodhilove (8/26/2008)
I was wrong the edition is standard for the instances. Is there any advice dealing with paging with this?
Standard edition ignores the locked pages setting. I would suggest, 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
August 27, 2008 at 1:44 am
What error do you get from attaching? If you can't attach the DB, then you're only real option is to restore the backup you have and live with the data...
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
August 27, 2008 at 1:39 am
Strange. Did you run it in database 6?
Have you dropped/truncated any tables since the deadlock message? It could account for why the partition is no longer there.
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
August 27, 2008 at 1:36 am
On 64 bit systems you should limit the max memory. SQL's quite capable of taking all tha available memory and starving the OS. Try setting it to 6.5GB. Dunno 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
August 26, 2008 at 2:57 pm
SQL 2000 or SQL 2005? The checkDB output looks like SQL 2005.
Do you have a clean backup?
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
August 26, 2008 at 2:54 pm
Once you've done the migation, be sure to update all the statistics and do a checkDB.
SQL 2005 can use the SQL 2000 statistics, but badly. Queries often run slower until...
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
August 26, 2008 at 2:34 pm
Add appropriate indexes and make sure that the query is written so as to use them. Without seeeing the query (and preferably also the execution plan) it's hard to be...
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
August 26, 2008 at 2:31 pm
light.harper (8/26/2008)
But, what I can't explain, is why the simple fact of reset the sql agent will fix this for some hours.
You're not resetting SQL agent. Those commands you listed...
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
August 26, 2008 at 2:16 pm
Jeffrey Irish (8/26/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
August 26, 2008 at 2:05 pm
Please don't cross post. It just wastes people's time and fragments replies. Many of us read all the forums.
No replies to this thread please. Direct replies to:
http://www.sqlservercentral.com/Forums/Topic558976-1063-1.aspx
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
August 26, 2008 at 9:22 am
Viewing 15 posts - 44,821 through 44,835 (of 49,552 total)