Viewing 15 posts - 8,326 through 8,340 (of 49,552 total)
How do you know that there's table-level locking being used?
Deadlock graph please, table definitions, index definitions.
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
July 30, 2014 at 9:15 am
Make sure the files aren't read-only, make sure the folder isn't read-only (check parent folder too). Make sure that the SQL Server service account has full permissions on the 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
July 30, 2014 at 5:33 am
Google for mark russinovich windows memory and you'll find a tonne of stuff. That's OS-level memory management though, not SQL's memory management.
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
July 30, 2014 at 3:56 am
Koen Verbeeck (7/29/2014)
From time to time they organize some evening sessions, but lately they seem to have trouble finding speakers.
Are you open to remote speakers?
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
July 29, 2014 at 11:28 am
I said nothing implying you should have repaired...
See if you can get some automated restore tests set up. Restore backups on another server, run CheckDB. Off the prod server means...
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
July 29, 2014 at 10:17 am
What exactly do you mean by 'OS cache'?
SQL uses memory outside of the buffer pool, but it's no the OS's memory, it's SQL's 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
July 29, 2014 at 9:58 am
Start with regularly tested backups and frequent database integrity checks. You should be running integrity checks often enough that it's caught before ending up in the backups. Or, if there...
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
July 29, 2014 at 9:47 am
The Dixie Flatline (7/28/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
July 28, 2014 at 12:01 pm
quackhandle1975 (7/28/2014)
[font="Arial Black"]A person who is very knowledgeable about or skilful in a particular area (noun)
+
Having or involving a great deal of knowledge or...
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
July 28, 2014 at 11:47 am
quackhandle1975 (7/28/2014)In answer to your question, possibly an expert has a set level of knowledge? Someone to get the job/task done?
If that's your definition of expert (just enough...
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
July 28, 2014 at 3:28 am
Sometimes you don't want to rebuild an index, no matter what its fragmentation.
Sometimes the fragmentation doesn't matter.
The challenge of deciding, automatically, when one can take a huge table completely offline...
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
July 28, 2014 at 2:43 am
prasantiki (7/27/2014)
MIRRORING feature not depricated in SS2012 instead it is enhanced as Always On
Mirroring is deprecated. Availability Groups is a new feature, not a direct upgrade (it's a mix 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
July 27, 2014 at 3:54 pm
quackhandle1975 (7/27/2014)Gail I would be interested to hear your thoughts on why they are not even close to expert level.
No, you don't want to. 😉
Tell me, if someone claims to...
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
July 27, 2014 at 2:11 pm
You have an expensive, long-running query. That's about all that can be said from the details given. If you want to know more, figure out (from the DMVs) who's running...
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
July 27, 2014 at 10:14 am
My general rule for this:
If the clustered index key is needed in the index (to cover a query or to make it useful), then it should be there. If it...
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
July 27, 2014 at 10:12 am
Viewing 15 posts - 8,326 through 8,340 (of 49,552 total)