Viewing 15 posts - 12,781 through 12,795 (of 22,214 total)
It really sounds like you've got a non-standard design, so I doubt any standard set of checklists on performance tuning is going to help. All the stuff Wayne supplied is...
April 12, 2011 at 6:35 am
Piling on, Michele's scripts are excellent. I'd absolutely support putting those in place on any production system I supported.
April 12, 2011 at 6:30 am
Craig Purnell (4/9/2011)
I have noticed that there are not any presentations on SQL Agent at the various SQL Saturday events and thought to fill a gap:
SQL Agent for the Beginner...
April 11, 2011 at 4:20 pm
Scalability Doug (4/5/2011)
Ever wonder what's in your SQL Plan cache? Wonder...
April 11, 2011 at 4:17 pm
Yep, absolutely, Itzik's books are the way to go.
April 11, 2011 at 10:01 am
CANCER (4/8/2011)
This is what i am getting when i try to collect execution plan.
The query has exceeded the maximum number of result sets that can be displayed in the Execution...
April 11, 2011 at 4:56 am
No short answers here. Are you sure it's memory that's the issue. Have you looked at wait states on the server? What are things waiting on? Have you gathered metrics...
April 8, 2011 at 6:10 am
Just so you know, certification is unlikely to help you get hired or get started in a DBA job. In general, you're better off working your way in to a...
April 8, 2011 at 6:09 am
CANCER (4/7/2011)
thanks for your reply
yes the db is in full recovery and log backups job is running succesfully for every hour.
we have clustered and non-clustered indexes on tables and there...
April 7, 2011 at 6:24 pm
Well, the optimizer isn't dumb, so it makes me wonder if something in your code is causing the problem. That's usually the issue.
April 7, 2011 at 11:05 am
Sounds like you have a couple of separate issues.
On the log, is your database in Full recovery? If so, are you running log backups? If your database is in...
April 7, 2011 at 11:03 am
Rather than going to dynamic SQL, have you looked into using SSIS. It's a great ETL tool and you can automate it's behavior, it'll work with referential constraints, there are...
April 7, 2011 at 10:59 am
It depends on the SAN and the software used there. There are transaction aware softwares used on some SAN systems that can copy the database from one location to another,...
April 7, 2011 at 10:56 am
After the upgrade did you manually update all the statistics? If not, those are slowly being recreated and you should see better performance eventually. If you did that, then it's...
April 7, 2011 at 10:52 am
If you have two completely different plans in cache, it's probably the connection settings, specifically the ANSI settings, that are different between Management Studio and the application. Focus there.
April 7, 2011 at 10:37 am
Viewing 15 posts - 12,781 through 12,795 (of 22,214 total)