Viewing 15 posts - 2,266 through 2,280 (of 49,552 total)
ChrisM@Work (10/6/2016)
GilaMonster (10/6/2016)
Eirikur Eiriksson (10/6/2016)
Using a conditional IF statement is by far the simplest way of doing this.And is prone to the performance-related problems that Chris alluded to.
https://www.simple-talk.com/content/article.aspx?article=2280
We must 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
October 6, 2016 at 11:22 am
Just had one of the new staff members stop me in the kitchen to tell me about his friend who runs the SQL user group (he doesn't though does 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
October 6, 2016 at 6:52 am
Eirikur Eiriksson (10/6/2016)
Using a conditional IF statement is by far the simplest way of doing this.
And is prone to the performance-related problems that Chris alluded to.
https://www.simple-talk.com/content/article.aspx?article=2280
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
October 6, 2016 at 6:09 am
You've getting 'bad' plans in cache, sometimes the query gets a good plan on the first run (when the restart or maxdop 'works') and sometimes it gets a bad plan...
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
October 5, 2016 at 12:14 pm
1) Changing the maxdop setting clears the plan cache.
2) It's probably got nothing to do with maxdop
3) Extremely unlikely
You've probably got something like bad parameter sniffing or similar resulting 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
October 5, 2016 at 9:11 am
Separate files.
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
October 5, 2016 at 8:50 am
hurricaneDBA (10/5/2016)
It's done once a day due to space limitations at work
Doesn't make sense. The total size of the log backups will be about the same whether they're backed...
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
October 5, 2016 at 7:09 am
And why are you only backing the logs up once a day? The reason that logs get backed up is for recovery purposes, so that the database can be restored...
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
October 5, 2016 at 6:52 am
hurricaneDBA (10/5/2016)
Thanks for the reply GailI have 3 txn logs which have reached 3 GB.
What's the recommended route?
Leave them alone is the usual recommendation for log files
I know shrinking...
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
October 5, 2016 at 6:48 am
Log backups truncate the log, as in mark the log space as reusable. The do not reduce the size of the file.
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
October 5, 2016 at 6:36 am
Get someone in to do a performance tuning exercise on your server. That's about all I can suggest with such little 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
October 5, 2016 at 3:03 am
Oh, you mean the max size, not the growth.
It's 'limited' to 2TB, which is the maximum allowable size of a log file, so it's essentially the same as unlimited.
Not...
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
October 5, 2016 at 1:07 am
CferMN (10/4/2016)
Could you please explain how to tell what the table is most frequently filtered by or how to tell the most common predicate used against the table?
You go 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
October 4, 2016 at 1:58 pm
The screenshot shows the file growth is 10MB, exactly as the ALTER DATABASE specified. So, what's wrong?
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
October 4, 2016 at 8:21 am
That should work fine. Can you post a screenshot of the file properties after running that?
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
October 4, 2016 at 7:00 am
Viewing 15 posts - 2,266 through 2,280 (of 49,552 total)