Viewing 13 posts - 1 through 13 (of 13 total)
Can you run the backup command from the Query window
and then note the time taken to complete the backup and let us know
BACKUP DATABASE <your dbname> TO...
September 5, 2011 at 11:29 am
Hello Mr SQLDBA
As you posted 1) You don't want to shrink the log
...
September 5, 2011 at 10:30 am
Are you taking this backup in local disk or in network share drive?
September 5, 2011 at 8:52 am
you know the exact fragmented index Ok great .
Right now I can clarify.. what I mean rebuild index in chunk is one index at a time. 🙂
August 10, 2011 at 7:02 pm
Did you try the below option
1=>Change the database recovery model to Bulk..
2=>Run the below query to find the highly fragmented index
select
object_name(itable.object_id) as tablename,
itable.name as IndexName,
indexfrag.avg_fragmentation_in_percent
from sys.dm_db_index_physical_stats(db_id(), null, null, null,...
August 9, 2011 at 6:42 pm
You can try the below option to detect the issue and able fix it accordingly.
=========================================================
1) If SQL is a named instance check that the SQL browser is running (SQL configuration...
August 8, 2011 at 3:31 pm
Need to do this basic thing
1) How are you connecting (Application connection string or Management strudio)
2) Try to connec to SQL server from management studio with the same credential...
May 18, 2010 at 1:04 am
I have two simple recommendation
1) Check
use tempdb
DBCC OPENTRAN =>Find if there any open spid and then use
...
April 27, 2010 at 9:00 pm
A company always wants to utilize it resource to a maximum extent. They may prefer a multiple skill set resource who can feet to there multiple requirement (cost effective ?)
This...
March 17, 2010 at 8:16 am
If pages >1000 then you can do defragmentation
I suggest instaead of looping throgh sysobjects and doing defragmentation you can take a maintenance window and run this command
use [DatabaseName]
EXEC...
March 16, 2010 at 10:00 pm
You might have to monitor multiple server and multiple instances if this is true then
1.Create a centralize monitor server (SQL server with single instance)
2.Create a table and store the SQL...
March 16, 2010 at 9:52 pm
I have a question why are you doing so frequent index organize and rebuild?
I suggest to investigate is the index really required to rebuild so frequently?
...
March 16, 2010 at 12:41 am
Always learning a new thing will be adding a feather to your cap. But you need to analyze which way it is going to help you in your career. A...
March 15, 2010 at 11:22 pm
Viewing 13 posts - 1 through 13 (of 13 total)