Viewing 15 posts - 45,946 through 45,960 (of 49,552 total)
Check some of the other SQL objects and counters.
I know there's a way to fix this, but I can't remember offhand.
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 4, 2008 at 12:36 am
Two of the rules of database design and normalisation that you need to consider here are:
- All columns should contain atomic entries
- You should not store redundant 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
July 4, 2008 at 12:32 am
Do you have a backup of the master database from before the deletions?
Deleting directly from sysxlogins is a little (no, actually it's very) extreme and there probably is another way....
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 4, 2008 at 12:14 am
Check some of the other SQL counters. I have seen cases before where all of the SQL-related perfmon counters read 0.
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 4, 2008 at 12:10 am
Hmmm.
Check the source database please, make sure that you have either torn page detection or checksum (open the database properties, go to options and scroll down to 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
July 4, 2008 at 12:03 am
Mani Singh (7/3/2008)
and the UPDATEUSAGE will help to rearrange the pages.
All update usage does is fix the metadata with regards to the size of tables. It doesn't rearrange anything....
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 4, 2008 at 12:01 am
When you run checkdb, run it with no_infomsgs, unless you need to see the count of rows and pages per table (usually not), and note that it is a very...
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 3, 2008 at 11:59 pm
Very strange...
Do you have space on the source server to restore one of the full backups that produces an error on the standby server? If so, please restore the 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
July 3, 2008 at 3:25 pm
Have you done a checkDB on the source database?
While it's not unheard of for a backup to have an error, to have multiple backups producing the same error is 'unusual'...
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 3, 2008 at 3:11 pm
If you're running the queries you should be able to extract the plans from the cache. You can retrieve the text of the query from the cache also. Dunno 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
July 3, 2008 at 3:01 pm
Tom Brown (7/3/2008)
90. Thats all - and it seems to work, - but performance seems sluggish, would any of these DBCC commnands help?
Update statistics on all of...
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 3, 2008 at 2:34 pm
If you're using 2005, you can retrieve the xml plans from the plan cache. Use the sys.dm_exec_query_stats and the sys.dm_exec_query_plans DMVs. Or you can get profiler to capture the plans...
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 3, 2008 at 2:28 pm
Phil Factor (7/3/2008)
I'm so pleased you got the recognition. I'm a great fan of your forum entries. I was trying to find my favourite one of all, in which you...
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 3, 2008 at 11:02 am
Grant Fritchey (7/3/2008)
I had to go and look QFT up. :ermm:
Sorry.
For anyone else reading. QFT = "Quote For Truth"
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 3, 2008 at 10:39 am
Grant Fritchey (7/3/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
July 3, 2008 at 10:30 am
Viewing 15 posts - 45,946 through 45,960 (of 49,552 total)