Viewing 15 posts - 10,591 through 10,605 (of 49,552 total)
Why is AWE not enabled?
Is /3GB switch on?
What is the definition of the procedure with objectID 1417080505 in database 5? Do you know why it's compiling frequently? Same for procedure...
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
December 20, 2013 at 5:50 am
Please don't cross post. It just wastes people's time and fragments replies. No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1524934-3387-1.aspx
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
December 20, 2013 at 5:44 am
If you change the sp_executesql to a PRINT, you should see exactly why it's not working.
What your code generates is this:
CREATE PARTITION FUNCTION DatePartitionFunction (DATETIME) AS RANGE RIGHT FOR
VALUES...
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
December 20, 2013 at 2:12 am
rajemessage 14195 (12/20/2013)
but if possible please write a word for use of (tsql vs trace) in Database Engine Tuning Advisor .
I answered that one
GilaMonster (12/17/2013)
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
December 20, 2013 at 12:36 am
Tune the procedure?
Optimise the queries, tune the indexes so that you reduce the CPU and time required for the procedure. Hard to offer anything more specific without seeing code,...
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
December 20, 2013 at 12:15 am
Chapter 1 of http://www.red-gate.com/community/books/accidental-dba, there's almost certainly something in http://www.amazon.com/Server-Performance-Tuning-Distilled-Experts/dp/1430219025/ref=tmm_pap_title_0?ie=UTF8&qid=1387523151&sr=8-1 and my manual methods are detailed in https://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/
Or buy a good 3rd party monitoring tool
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
December 20, 2013 at 12:13 am
naga.rohitkumar (12/19/2013)
1. how will you do san migration of sqlserver clusternodes
A little vague and will depend on the SAN. Best to speak with the SAN admin and identify exactly what...
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
December 20, 2013 at 12:11 am
Sean Lange (12/19/2013)
I assumed it is light-hearted and that "winning" is very possibly more like losing because you get some silly booby prize and public humiliation as your "award". 😀
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
December 19, 2013 at 2:33 pm
Sean Lange (12/19/2013)
Koen Verbeeck (12/19/2013)
GilaMonster (12/19/2013)
https://www.surveymonkey.com/s/TribalAwardsVoting
😀 :hehe:...
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
December 19, 2013 at 2:26 pm
Have a read through this, see if it helps or at least points you to more specific and useful error messages:
https://www.simple-talk.com/sql/backup-and-recovery/the-sql-server-instance-that-will-not-start/
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
December 19, 2013 at 2:20 pm
Not that I would stoop so low as to beg for votes, but I do need a new costume (Star trek if anyone cares)
https://www.surveymonkey.com/s/TribalAwardsVoting
😀 :hehe: 😉
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
December 19, 2013 at 2:02 pm
JimS-Indy (12/19/2013)
Guys, as you can see from my attachment, I run the log backup every night.
Yes, and that is the problem. The fact that the log backup was run...
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
December 19, 2013 at 12:42 pm
Brandie Tarvin (12/19/2013)
GilaMonster (12/19/2013)
Full backups do not break the log chain. Differential backups do not break the log chain
I know that. The chain that was broken was between the differential...
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
December 19, 2013 at 11:14 am
Restore full with norecovery
restore logs, in sequence, with norecovery, stopat = 'time you want to restore to'
Full backups do not break the log chain. Differential backups do not break 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
December 19, 2013 at 10:36 am
DeWayne_McCallie (12/19/2013)
Why consolidate when you can virtualize and license SQL at the Host level?
That's a form of consolidation, multiple physical machines being consolidated into multiple virtual machines on 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
December 19, 2013 at 10:26 am
Viewing 15 posts - 10,591 through 10,605 (of 49,552 total)