Viewing 15 posts - 26,311 through 26,325 (of 49,552 total)
Logins allow connections to the server. Users allow access to the specific databases. A user with no login cannot ever connect to the server (though can be used for impersonation)
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
May 5, 2011 at 4:57 am
No, both use the index that they say they use. The difference is in how they use it.
A seek uses the upper levels of the b-tree to locate a row...
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
May 5, 2011 at 3:33 am
Did you look at Books Online (the SQL help file) as Lutz suggested?
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
May 5, 2011 at 2:23 am
Fal (5/5/2011)
Thanks for this Steve. I was beginning to get worried that no one could list a single item/thing guaranteed to hit tempdb regardless of memory.
Bear in mind 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
May 5, 2011 at 2:12 am
Yes, but the point is you had a backup. If you had not had that database backup, you would not have been able to recover anything.
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
May 5, 2011 at 2:11 am
Have you rebuilt all indexes and updated all statistics since the upgrade?
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
May 4, 2011 at 11:45 pm
Someone's playing with updating the system tables. Very bad thing to do, easy to break stuff and not notice for log periods of time.
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
May 4, 2011 at 11:36 pm
tony-844756 (5/4/2011)
I'm using the Resource Monitor within the Windows 2008 task manager and applying a filter to SQLServer.exe
Never use task manager to monitor SQL's memory. It lies, especially 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
May 4, 2011 at 11:34 pm
I wouldn't say disk contention (but I'm not a SAN expert). Check the physical connections, switch, anything between the server and SAN. From the Windows error log, the OS can't...
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
May 4, 2011 at 3:19 pm
p.s. If I were you, I'd be doing checkDB more often than once in 2 months.
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
May 4, 2011 at 2:47 pm
Looks like a hardware issue. Server is losing contact with the underlying drives.
SAN storage?
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
May 4, 2011 at 2:44 pm
GilaMonster (4/12/2011)
How are you monitoring the memory used?
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
May 4, 2011 at 12:52 pm
Worst setup ever...
I once saw an environment where every application and then some (from SQL Server to custom windows services to vendor products) ran as Domain Administrator (not local admin,...
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
May 4, 2011 at 12:32 pm
Call customer support and open a case. They have the tools to investigate stack dumps, we don't.
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
May 4, 2011 at 12:14 pm
Could something disk-intensive have been running at the time? (file copies, checkDB, backups, etc)
Disk queue length is a poor counter these days. Hard to interpret (because of all the stuff...
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
May 4, 2011 at 8:44 am
Viewing 15 posts - 26,311 through 26,325 (of 49,552 total)