Viewing 15 posts - 44,806 through 44,820 (of 49,571 total)
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...
August 29, 2008 at 8:19 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...
August 29, 2008 at 8:07 am
This piece is wrong
IF @vFieldsDataType='VARCHAR' OR @vFieldsDataType='TEXT'
...
August 29, 2008 at 8:04 am
Does sql_login have rights on the blacklist table?
What you can do to debug is something like this (untested):
CREATE TRIGGER connection_limit_trigger
ON ALL SERVER WITH EXECUTE AS 'sql_login'
FOR LOGON
AS
BEGIN
BEGIN TRY
IF ORIGINAL_LOGIN()= 'sql_login'...
August 29, 2008 at 8:02 am
Have you done a full stats update on all tables after the 2005 upgrade? If not, that could result in non-optimal query plans.
Run profiler for a while and capture the...
August 29, 2008 at 2:28 am
Could you post this as a bug on Connect please?
August 29, 2008 at 1:50 am
That's probably what happened. The owner of the site said that page hasn't been changed in years.
August 29, 2008 at 1:34 am
Master contains all the information on the logins on the SQL server, as well as the database references, the linked servers, server-level triggers and server settings.
Model is used to...
August 29, 2008 at 1:33 am
Denise McMillan (8/28/2008)
Thank you, that's what I thought. But our vendor is trying to say that all rights to all databases come with public role.
Tell then to stop talking...
August 28, 2008 at 4:01 pm
Depends on what permissions have been granted to the public role. If no permissions have been granted to it, then users with just public will have no rights to do...
August 28, 2008 at 2:48 pm
It's teling you that there are slow IOs occuring. The typical range for a single IO operation should be 10-50 ms at the most. The warning is saying that in...
August 28, 2008 at 12:25 pm
Maybe these two blog posts will help?
http://www.sqlskills.com/blogs/paul/2007/10/25/DebunkingACoupleOfMythsAroundFullDatabaseBackups.aspx
http://www.sqlskills.com/blogs/paul/2008/01/31/MoreOnHowMuchTransactionLogAFullBackupIncludes.aspx
August 28, 2008 at 11:39 am
DBCC DBREINDEX will do a stats update with full scan as it rebuilds the index.
DBCC INDEXDEFRAG will not update the statistics at all.
I would suggest that you do different stats...
August 28, 2008 at 10:57 am
Viewing 15 posts - 44,806 through 44,820 (of 49,571 total)