Viewing 15 posts - 8,731 through 8,745 (of 49,552 total)
SQLRNNR (6/13/2014)
GilaMonster (6/13/2014)
- Tune a proc quick, then go home
- Wait, it's got user defined functions
- Wait, the UDFs have cursors
-...
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
June 13, 2014 at 8:31 am
I doubt anyone knows who the responsible party is. Tuning a client's system, one that's been developed by 'experts' and enhanced by everyone and their dog and has been around...
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
June 13, 2014 at 8:25 am
That would be handy.
Maybe bump this thread mid next month, as Steve's on vacation.
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
June 13, 2014 at 8:22 am
Thought process of last 10 minutes.
- Tune a proc quick, then go home
- Wait, it's got user defined functions
- Wait, the UDFs have cursors
- I'm going...
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
June 13, 2014 at 8:20 am
Server-side trace or extended events session
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
June 13, 2014 at 5:08 am
It will not.
Please in future post new questions in a new thread. Thanks
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
June 13, 2014 at 4:26 am
Ok, that really is something running CheckDB. From the username, looks like it might be coming from BackupExec. BackupExec may be doing a checkDB before each full backup, that could...
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
June 13, 2014 at 3:48 am
Are you absolutely sure that something/someone didn't run a full backup between the two?
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
June 13, 2014 at 2:44 am
adzuanamir (6/12/2014)
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
June 13, 2014 at 2:27 am
No. Index maintenance will invalidate all plans anyway, they'll recompile on their next execution.
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
June 13, 2014 at 2:25 am
StephenNL (6/12/2014)
I am thinking about updating statistics regularly now.
Don't just think about it. 😀
The reason it helped here is that the 2005+ statistics have a different structure than the 2000...
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
June 12, 2014 at 1:48 pm
In that case you need to analyse first whether you have IO bottlenecks. Pointless splitting files if you aren't bottlenecked on IO. You need to look for tables accessed together...
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
June 12, 2014 at 1:41 pm
Chowdary's (6/12/2014)
Actually am having only one database ,In that the User is not there to drop at database level
I said nothing about the login being a user in the database....
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
June 12, 2014 at 8:00 am
There's a bunch of problems with that procedure. Start with these two blog posts:
http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/
http://sqlinthewild.co.za/index.php/2008/05/22/parameter-sniffing-pt-3/
Fixing those two problems should help a lot.
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
June 12, 2014 at 7:20 am
IT researcher (6/12/2014)
The SQL server instance is used by employees in office. So it will be running only during office timings. So we keep the server OFF during night.
Again,...
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
June 12, 2014 at 7:07 am
Viewing 15 posts - 8,731 through 8,745 (of 49,552 total)