Viewing 15 posts - 841 through 855 (of 2,462 total)
SQLSACT (11/9/2012)
Bhuvnesh (11/9/2012)
SQLSACT (11/9/2012)
I'm trying to understand the behaviour of clean pages in the buffer pool
see this
"Dirty" pages are pages where data has been changed but has not...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 9, 2012 at 4:43 am
naga.rohitkumar (11/7/2012)
and another thing
1.what can as a DBA we can look care for performance improvement of a server which is running sqlserver...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 9, 2012 at 4:18 am
amarendra.sahoo (11/5/2012)
One of my query execution plan shows 'Clustered Index Update' @ a cost of 152%.
are you using any third party tool like sql sentry ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 9, 2012 at 4:15 am
Have you tried to repeat same test in new server? see and paste the result here
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 9, 2012 at 3:49 am
worth reading 🙂
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 9, 2012 at 3:45 am
sanket kokane (10/31/2012)
you have scheduled transactional log backup then why there is job for truncate log file :blink:
+1
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 9, 2012 at 3:33 am
SQLSACT (11/9/2012)
I'm trying to understand the behaviour of clean pages in the buffer pool
see this
"Dirty" pages are pages where data has been changed but has not yet been...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 9, 2012 at 3:17 am
see these links
http://www.sqlservercentral.com/blogs/sql_server_dba/2011/11/28/sql-dirty-pages-/
http://msdn.microsoft.com/en-us/library/aa337560(v=sql.105).aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 9, 2012 at 2:33 am
AndrewSQLDBA (11/8/2012)
1 would need to become 100.00
HOw can this be possible or yuor are trying to say 1.00
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 9, 2012 at 2:26 am
apatel62 (11/7/2012)
Two suggestions 1) log(ldf) and data(mdf) files on physically separate disks.
2) Partition the table so that records to be deleted are distributed among several spindles
if...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 8, 2012 at 11:44 pm
sanket kokane (11/7/2012)
Bhuvnesh (11/7/2012)
DesmoShane (11/6/2012)
will the resulting non-clustered indexes will they be rebuilt automaticaly and be an online operation
YEs. any change to the cluster keys forces all the non-clustered...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 7, 2012 at 4:44 am
i had impression that there are two options
I have a daily full db backup via SQL maintenance plan to file system at 10pm.
AND
I also have a daily direct...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 7, 2012 at 4:02 am
DesmoShane (11/6/2012)
will the resulting non-clustered indexes will they be rebuilt automaticaly and be an online operation
YEs. any change to the cluster keys forces all the non-clustered indexes to be...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 7, 2012 at 3:52 am
you can also opt SORT_IN_TEMPDB = ON to divert the IO load to tempdb too
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 7, 2012 at 3:46 am
@sanket why tuesday full back which is not there (for arcserve )
see
I also have a daily direct backup of database via arcserve SQL agent to tape at 11pm:
Monday to Saturday...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 7, 2012 at 3:31 am
Viewing 15 posts - 841 through 855 (of 2,462 total)