Viewing 15 posts - 7,321 through 7,335 (of 49,552 total)
No. Because
Msg 8921, Level 16, State 1, Line 1
Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous...
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 12, 2014 at 12:07 pm
Before you change maxdop, could you look through the startup messages in your error log and post any that reference NUMA?
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 12, 2014 at 11:30 am
zedtec (11/12/2014)
So to use extended events would I just create a new session in SSMS 2012?
Create a new session, pick the events, add filters, run session. That's the basics, but...
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 12, 2014 at 5:12 am
Well, three jobs. You don't need to use maint plans for Ola's stuff.
Why is that a problem? Every single prod SQL instance I set up maintenance on gets 4 jobs...
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 12, 2014 at 4:46 am
Please post EXACT descriptions and all error messages encountered, along with a precise timeline of exactly what happened.
Alternately, restore from your last good backup.
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 12, 2014 at 4:42 am
There's always at least one filegroup in a database. If you haven't created any filegroups, then all files will be part of the PRIMARY filegroup and data will be written...
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 12, 2014 at 4:39 am
That's not how SQL Server works. You enter passwords to connect to the instance and then the login's permissions determine whether or not it can access the 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
November 12, 2014 at 1:24 am
I suppose that has to do with possible corruption in the file rendering all the backups inside unusable, point taken.
No, I was more thinking about someone accidentally deleting a 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
November 11, 2014 at 3:16 pm
Try working through this: https://www.simple-talk.com/sql/backup-and-recovery/the-sql-server-instance-that-will-not-start/
Alternatively, if you want advice, please post exact error messages and detailed description of exactly what happened.
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 11, 2014 at 3:13 pm
You need to google and do some research because it's not clear what edition you need, whether you can use the free Express or not, and we don't know your...
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 11, 2014 at 1:16 pm
Luke L (11/11/2014)
Since its a parralelism wait is there any way you know of to force the issue to make it repeatable. ..
Not offhand, and gut feel is 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
November 11, 2014 at 12:29 pm
Quote from Steve's post
You can google for those editions and the download locations.
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 11, 2014 at 12:14 pm
You'll probably get Oracle questions answered faster on an Oracle forum
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 11, 2014 at 12:08 pm
Those latches are to do with parallel table scans. Two steps I would suggest
- Increase cost threshold for parallelism (especially if it's at the default of 5) and consider changing...
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 11, 2014 at 12:04 pm
ahfb (11/8/2014)
if i have another admin user ,is it possible to recovery sa password ?
Let me quote the post right above yours
SQL passwords are stored with a on-way hash. They...
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 11, 2014 at 12:02 pm
Viewing 15 posts - 7,321 through 7,335 (of 49,552 total)