Viewing 15 posts - 45,616 through 45,630 (of 49,552 total)
Table spool/lazy spool is a temp storage of a interim resultset so that the query processor doesn't have to regenerate the resultset. Often found with sorts, aggregations in subquery, linked...
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 17, 2008 at 5:22 am
michael vessey (7/17/2008)
added benefit of this is that you can 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
July 17, 2008 at 5:03 am
Or you can use the newer DMVs
SELECT count(*) from sys.dm_exec_connections
You can also get the IP address fron the same dmv
SELECT login_name, HOST_NAME, client_net_address
FROM sys.dm_exec_connections c INNER JOIN sys.dm_exec_sessions s...
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 17, 2008 at 4:32 am
It is possible to restore MSDB, but the process is not the same as for one of the user databases.
See - http://msdn.microsoft.com/en-us/library/ms190749.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 17, 2008 at 4:28 am
xp_cmdshell with the appropriate proxy account created.
Look up proxy aaccounts in books online. You don't have to be admin to execute xp_cmdshell
If you're using stored procedures, consider the EXECUTE...
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 17, 2008 at 4:05 am
Mike, as GSquared suggested on another thread, perhaps you should consider getting a competant SQL consultant in to help you with the myriad of performance problems that you seem 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 17, 2008 at 1:43 am
Perhaps you would like to post the query, the table structure and the indexes?
For now, it looks like the plan that the optimiser picked (the coverign index with a scan)...
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 17, 2008 at 1:39 am
It's a red flag. It means that a sort or hash couldn't fit into memory and was forced to disk. Either you;re doing massive hashes and/or sorts, or you're low...
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 17, 2008 at 1:34 am
phoenixrising1599 (7/16/2008)I have min and max server memory set to default (dynamic configuration)
I would recommend changing that. On 64 bit with lots of memory, SQL's more than capable of using...
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 17, 2008 at 1:30 am
Just converting them to stored procs, probably not.
To fix deadlocks, you need to identify the cause of that deadlock and fix that. It's probably bad code, bad indexes 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 17, 2008 at 1:23 am
Looking at that, my first pass suggestion for indexs (without any testing done) would be:
ParentTable
- Clustered index on the primary key.
- Possible nonclustered index on Col2, Col3 (if 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
July 17, 2008 at 12:51 am
sultankahut (7/16/2008)
After that a series of other messages like "SQL Server is terminating in response to a 'stop' request from Service Control Manager.
That means that either somebody stopped SQL (issuing...
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 17, 2008 at 12:27 am
J (7/16/2008)
SELECT DISTINCT ntext
would mean for each record in the query, go get the text stored at pointer of ntext...
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 17, 2008 at 12:18 am
Sandy (7/16/2008)
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 17, 2008 at 12:14 am
noeld (7/16/2008)
But I would go even further. When you find yourself in this situation you should try to call the webservice from the "CLIENT" not on the server.
Fully agreed....
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 17, 2008 at 12:10 am
Viewing 15 posts - 45,616 through 45,630 (of 49,552 total)