Viewing 15 posts - 45,376 through 45,390 (of 49,552 total)
alimcitp (7/29/2008)
Thanks for no help
If you read all of my last post you would have seen a request for more information on exactly what was wrong with it. Had...
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, 2008 at 9:17 am
Why is management studio even installed on the servers? Workstation utilities should not be installed on servers.
Second, why do your users have enough privileges to log on to a production...
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, 2008 at 7:16 am
I think you'll have to find the source of these to get any clarity on why the locks are IX.
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, 2008 at 7:03 am
Look up the sp_trace stored procedures in books online. That should give you a good overview of how they work. You can create a trace in profiler, then export 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
July 29, 2008 at 7:02 am
If you didn't have some form of tracing enabled, there's no way to tell who changed the proc.
As for profiling a prod server, via the GUI is a fairly bad...
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, 2008 at 4:18 am
GO is not a T-SQL command. It's a client tool statement that signals the end of a batch. You don't need it here.
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, 2008 at 4:14 am
Please don't cross post. It just wastes people's time and fragments replies. Many of us read all the forums.
No replies to this thread please. Direct replies to :
http://www.sqlservercentral.com/Forums/Topic542367-9-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
July 29, 2008 at 4:13 am
Thing is, CheckDB does use a lot of tempDB space. There's no way to get it to use less. I would not suggest unrestricted growth, disk out of space errors...
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, 2008 at 4:09 am
Temp tables are dropped automatically as soon as the table goes out of scope or the connection that created it closes. Unless you're creating explicit tables in tempDB, there's 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
July 29, 2008 at 4:03 am
As far as I can tell from the deadlock graph, both parts of the deadlock are selects that are taking IX or SIX locks. If I've misinterpreted the deadlock graph,...
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, 2008 at 4:00 am
I was just wondering. It's not usual to see exactly the same problem from two different people.
There's an ongoing discussion over this elsewhere, I'll let you know if anything useful...
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, 2008 at 3:57 am
At this point I would strongly suggest that you look at getting a second array for the log files. 2 drives mirrored should be adequate (though RAID 10 is 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
July 29, 2008 at 3:56 am
Why do you say that subqueries, outer joins and NULL checks are bad?
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, 2008 at 3:43 am
Will take a look tomorrow (if no one else solves it in the meantime, that is). Is past bed time here.
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, 2008 at 3:22 pm
Is this the same problem that was posted on the sqlserver.programing newsgroup?
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, 2008 at 3:04 pm
Viewing 15 posts - 45,376 through 45,390 (of 49,552 total)