Viewing 15 posts - 45,451 through 45,465 (of 49,552 total)
sharon.bender (7/24/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 25, 2008 at 12:23 am
DKG (7/24/2008)
As its a part of replication, some times the transactions which is already replicated doesn't get clear from transaction log.In that case it would get clear by::
sp_repldone
True, for 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 25, 2008 at 12:17 am
ALIF (7/24/2008)
this database is a subcriber, will it affect the replication. if we change it to simple recovery mode.
No. Just be sure you're happy with the recovery implications
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 24, 2008 at 11:22 am
Does table1 have a clustered index in either environment? If not, please run the following and check the value of Forwarded records.
DBCC ShowContig ('t1',0) WITH TableRESULTS
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 24, 2008 at 11:18 am
What recovery mode are you using?
Do you have regular transaction log backups?
Is the database published for replication
What does the following query return for the offending database?
select name, recovery_model_desc, log_reuse_wait_desc from...
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 24, 2008 at 11:12 am
MrBaseball34 (7/24/2008)
GilaMonster (7/24/2008)
For structures like that, WITH RECOMPILE may 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
July 24, 2008 at 11:11 am
ALIF (7/24/2008)
shrink tempdb,or
detach the file and attach with a new one with 0 bytes
Shrinking a file that's full isn't going to achieve anything. It has no free space in 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 24, 2008 at 10:59 am
onlyanji4u (7/24/2008)
if your tempdb is full, try to change wherever places you use temporary tables with table variable.like DECLARE @temptb TABLE(id int,name char(10))
That's a common fallacy.
Table variables, like temp 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 24, 2008 at 10:55 am
An 823 error is often indicative of hardware problems, especially considering the suspect database you had last week. 823 means that the OS issued a read on a page and...
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 24, 2008 at 10:36 am
Identical hardware?
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 24, 2008 at 10:23 am
MrBaseball34 (7/24/2008)
There are 946000 records in the table and it take 30+ seconds to return results. I'm pretty sure that I need an index.
Probably. The problem is with the multiple...
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 24, 2008 at 8:10 am
Just beware of parameter sniffing. Taht format of where clause tends to have very bad plan reuse and intermittent bad performance.
For structures like that, WITH RECOMPILE may be necessary.
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 24, 2008 at 7:55 am
angie stein (7/24/2008)
Brandie Tarvin (7/24/2008)
Does this technobabble make sense?Ok, so it sounds like you should usually restrict the growth (esp. in prod), unless there's a good reason to do otherwise.
In...
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 24, 2008 at 7:53 am
Brandie Tarvin (7/24/2008)
Sheer laziness or the inability to properly determine the growth rate of your DB. @=)
Intersting opinion. 😉
My main system is more a datawarehouse than anything. It grows...
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 24, 2008 at 7:48 am
Brandie Tarvin (7/24/2008)
I'd really love to have enough partitions in my SAN to have more than one file for my TempDB. @sigh. Gail, you're making me jealous. @=)
They're...
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 24, 2008 at 7:40 am
Viewing 15 posts - 45,451 through 45,465 (of 49,552 total)