Viewing 15 posts - 4,261 through 4,275 (of 49,552 total)
That's not what I said.
Unless your database is case-sensitive (is it?), the UPPER is a complete waste of time. The default SQL collations are case-insensitive.
I also didn't say remove 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
November 17, 2015 at 5:05 am
Oh wow...
Ok, there's a whole bunch of problems here.
Firstly, unless you're dealing with case-sensitive database, the only thing those UPPER functions are doing is slowing things down. Is your database...
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
November 17, 2015 at 4:24 am
In that case, I'd suggest leave it and keep an eye on it.
If the stack dumps and hung schedulers happen again or start happening frequently, you may have a...
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
November 17, 2015 at 2:57 am
Backup/restore will the the easiest and probably the fastest.
You could buy a tool like Red Gate's SQLCompare and SQL DataCompare to sync the data and schema, but it's probably 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
November 17, 2015 at 2:53 am
GilaMonster (11/17/2015)
Has anything changed recently?Are you on the latest service pack of 2008 R2?
Anything since the restart?
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
November 17, 2015 at 2:25 am
Go sit with your storage admin and see if the two of you can work out why you're getting such slow throughput on a SAN. Work with him, don't just...
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
November 17, 2015 at 2:08 am
Cool, and what other errors/messages are you seeing in the error log?
Are you seeing frequent stack dumps and/or hung schedulers?
Has anything changed recently?
Are you on the latest service pack 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
November 17, 2015 at 2:06 am
Firstly, there is no case where a single perfmon counter tells you what to do. See chapter 1 of https://www.red-gate.com/community/books/accidental-dba
Sustained low page life expectancy suggests that you may have memory...
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
November 17, 2015 at 2:01 am
robert.sterbal 56890 (11/16/2015)
I think you have been trying too hard to teach someone without altering your approach if your response is that someone has asked a bad (as in ineffective)...
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
November 17, 2015 at 1:58 am
No, and it sounds like you may want to read through this: http://www.sqlservercentral.com/articles/Administration/64582/
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
November 17, 2015 at 1:50 am
With the very limited amount posted, and no other error messages, really hard to say anything useful.
If you're getting frequent stack dumps and hung schedulers, call product support (if 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
November 17, 2015 at 1:47 am
luissantos (11/16/2015)
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
November 16, 2015 at 1:36 pm
You can't restore master to a different version, it doesn't work. Script out everything (don't forget server config settings) and apply to the new instance. Only user databases should get...
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
November 16, 2015 at 1:35 pm
coolchaitu (11/16/2015)
Could you please advise on how to fix the issue.
The first thing you need to do is find out what the data loss allowance for this database is,...
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
November 16, 2015 at 1:33 pm
Steve Jones - SSC Editor (11/16/2015)
If you can't do anything else, then you can use the WITH TRUNCATE option to clear the log
Not on SQL 2008. WITH TRUNCATE_ONLY throws an...
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
November 16, 2015 at 1:24 pm
Viewing 15 posts - 4,261 through 4,275 (of 49,552 total)