Viewing 15 posts - 8,086 through 8,100 (of 49,552 total)
curious_sqldba (8/15/2014)
i can only scale-up so much on sql server, but if i have multiple databases i can easily scale-out them across multiple servers.
What is your current maximum sustained transactions/sec...
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 15, 2014 at 4:12 pm
curious_sqldba (8/15/2014)
In total there will be 10,000 commits per hour on the same log file
10 000 an hour? Unless my log file's on a 3.5" floppy disk, I'm pretty sure...
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 15, 2014 at 4:07 pm
Evil Kraig F (8/15/2014)
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 15, 2014 at 3:57 pm
Eirikur Eiriksson (8/15/2014)
Koen Verbeeck (8/15/2014)
GilaMonster (8/15/2014)
Eirikur Eiriksson (8/14/2014)
You can try out these methods as previously suggested
However OP said
I really don't like this temp table creation
So, no row number, no...
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 15, 2014 at 12:46 pm
They're just log backups. There's nothing different about log backups used with log shipping than log backups you'd get from maintenance 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
August 15, 2014 at 10:09 am
Take your last full backup, copy over all the logs that ran since that full backup (from the log shipping secondary), including one log backup that occurred after 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 15, 2014 at 5:21 am
Ah. Then out of ideas. Sorry I can't help.
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 15, 2014 at 4:12 am
Reorg of the clustered index, with lob_compaction on?
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 15, 2014 at 3:30 am
Try an index reorganise with LOB Compaction on
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 15, 2014 at 3:02 am
Backup the system databases.
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 15, 2014 at 2:24 am
WhiteLotus (8/14/2014)
What about if I want to know the query that consume the biggest memory ?
Your largest memory consumer won't be a query. Most of the memory will be going...
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 15, 2014 at 2:18 am
Eirikur Eiriksson (8/14/2014)
You can try out these methods as previously suggested
However OP said
I really don't like this temp table creation
So, no row number, no temp tables. Really limits 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 15, 2014 at 2:13 am
I have really un-fond memories of doing replication with an Oracle publisher (with SQL 2005). That was a nightmare, random data conversion errors that were incredibly hard to track (errors...
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 14, 2014 at 2:46 pm
Evil Kraig F (8/14/2014)
djj (8/14/2014)
ChrisM@Work (8/14/2014)
remember '76/'77
Wish I could remember what last year was like, I remember some nice days for '77 as I have a picture of me...
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 14, 2014 at 11:33 am
Gary Varga (8/14/2014)
Surely the big question is whether you will be sporting a matching Hawaiian shirt???
Steve's shirts don't match anything. Including themselves. 😀
p.s. Please donate fast, I need to know...
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 14, 2014 at 7:08 am
Viewing 15 posts - 8,086 through 8,100 (of 49,552 total)