Viewing 15 posts - 46,021 through 46,035 (of 49,552 total)
Does the poor performance occur at regular intervals or times?
Best thing would be to run profiler and perfmon during one of the slow periods. The profiler events you want are...
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 1, 2008 at 7:11 am
I think this may be worth opening a case with Microsoft's customer support services. It sounds like you've run into some form of bug.
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 1, 2008 at 7:08 am
But the server in question is running production exchange and file server?
Do you not have a development server somewhere?
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 1, 2008 at 6:08 am
I would strongly recommend that you run the tuning advisor against a copy of your production databse, not your production database itself.
Take a profile of the prod server to serve...
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 1, 2008 at 5:48 am
Why do you want to shrink the log?
If you bring the database online, you will not be able to restore more log backups.
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 1, 2008 at 5:36 am
No replies to this thread please. direct replies to:
http://www.sqlservercentral.com/Forums/Topic526415-24-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 1, 2008 at 5:22 am
Do you perhaps know what patches were installed?
Is there any possibility of uninstalling the updates one at a time until you find the offending one?
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 1, 2008 at 5:09 am
Depends. Is your database in full recovery mode? Do you have log backups scheduled? Are they running?
Do you have transactional replication?
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 1, 2008 at 2:44 am
Did anything change on the server between when the backups worked and now? Did you restore any databases, attach any databases, do anything with msdb?
Can you take a look in...
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 1, 2008 at 2:03 am
Tune the transaction log? I don't fully understand what you're asking?
Are you trying to clear out space in it?
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 1, 2008 at 1:58 am
Books online has a lot of info about the sp_trace procs.
You can also use profiler to generate a script for you. Set up a trace with the events and...
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 1, 2008 at 12:32 am
SQL has to do meta-data lookups whether or not * is specified as it has to find the types and the column lengths.
The reasons to not use select * ...
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 1, 2008 at 12:10 am
You can use the sys.dm_exec_sessions and sys.dm_exec_requests to see what's currently running on the server.
You can use the server-side trace procedures (sp_trace_*) to inplement a trace. They're the same procs...
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 30, 2008 at 11:55 pm
From the looks of the stats you posted, you have a very well-running SQL system that is on hardware more powerful than it currently needs.
Are you having performance problems, 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
June 30, 2008 at 2:50 pm
Brad M. McGehee (6/30/2008)
Oftentimes, it is more important to hire someone with the right attitude than specific knowledge.
Indeed, and I have several times recommended a hire just based on...
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 30, 2008 at 2:38 pm
Viewing 15 posts - 46,021 through 46,035 (of 49,552 total)