Viewing 15 posts - 44,776 through 44,790 (of 49,552 total)
If you can get the SPID for the process that is running the query that is running slow and then look at the status of that query in the results...
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
August 29, 2008 at 1:46 pm
Last point. Don't put a shrink database/file task in the maintenance plan.
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
August 29, 2008 at 1:12 pm
How did you manage to corrupt the files? Short of taking a hex editor to them, it shouldn't be possible for you to corrupt 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
August 29, 2008 at 1:12 pm
Prints are buffered and are not returned the the client immediatly. While I've never seen multiple prints out of order, I have seen them greatly delayed. Try replacing the print...
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
August 29, 2008 at 1:04 pm
Very strange.
Is the invoice verification using linked servers by any chance?
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
August 29, 2008 at 12:59 pm
Right now I'm thinking it's poossibly got something to do with compile time. Perhaps try getting the admins to run a trace on Cache hit, cache miss, cache insert, RPC...
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
August 29, 2008 at 12:57 pm
Ah. Fun.
How is the query constructed on the front end? Parmaterised (I somehow doubt) or concatenated strings?
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
August 29, 2008 at 10:13 am
I assume this is in a stored proc. Can you post the rest of the proc please?
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
August 29, 2008 at 9:14 am
One thing that may help.
convert(varchar,tab.TreatmenRegimenNumber)+ ','+convert(varchar,tab.RevisionNumber)
not in
(
select convert(varchar,TreatmenRegimenNumber)+ ','+ convert(varchar,RevisionNumber)
from TreatmentRegimen TR
...
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
August 29, 2008 at 9:12 am
Vika (8/29/2008)
The database suppose to be setup on the disk where everything gets backed up automatically but following the written instructions (that had an error in the path!) he set...
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
August 29, 2008 at 8:54 am
It's usually a good idea to create indexes on foreign key columns, however you should check and make sure that SQL is actually using them. You can do that by...
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
August 29, 2008 at 8:27 am
Sounds like it could be parameter sniffing.
http://sqlinthewild.co.za/index.php/2007/11/27/parameter-sniffing/
http://sqlinthewild.co.za/index.php/2008/02/25/parameter-sniffing-pt-2/
http://sqlinthewild.co.za/index.php/2008/05/22/parameter-sniffing-pt-3/
If you post the query, we could point out potential problems with it, give you an idea what to look for, and why...
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
August 29, 2008 at 8:19 am
See the post in the SQL 2000 forum:
http://www.sqlservercentral.com/Forums/Topic560970-5-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
August 29, 2008 at 8:10 am
Check the windows event log. There should be a record in the application log of SQL shutting down. There sshould also be the login name that requested the shutdown included...
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
August 29, 2008 at 8:07 am
This piece is wrong
IF @vFieldsDataType='VARCHAR' OR @vFieldsDataType='TEXT'
...
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
August 29, 2008 at 8:04 am
Viewing 15 posts - 44,776 through 44,790 (of 49,552 total)