Viewing 15 posts - 3,541 through 3,555 (of 4,745 total)
...er, your post fooled me, the rest of this thread is about cache flushes, not slow i/o, which your warning refers to.
You would be best starting a new thread but...
June 24, 2009 at 10:15 am
Vlad, nothing to do, its not an error, just informational. Just be aware restores will clear out your proccache.
I raised a request to change this behavior on technet but no-one...
June 24, 2009 at 9:07 am
Tao, I have not read this anywhere and its a guess so maybe I am setting myself up for a fall, but -
why does index data get deleted when...
June 23, 2009 at 4:19 pm
Tao Klerks (6/23/2009)
george sibbald (6/23/2009)
Apologies, just reread the options properly, they are correct. :blush:Sorry, I jumped the gun 🙂
no worries. Exactly what I did when I answered the...
June 23, 2009 at 4:23 am
Apologies, just reread the options properly, they are correct. :blush:
BOL does say indexes are deleted from index views. search on disabled indexes then see 'about disabled indexes'
June 23, 2009 at 4:16 am
As I understand it disabling the index does not delete the index, it remains in the system catalog but is not used by queries and is not maintained as the...
June 23, 2009 at 4:05 am
Glad it helped , thanks for the feedback.
Just noticed I in fact gave you an older version of the script that only handles two files, a data file and a...
June 22, 2009 at 5:00 pm
OK, this script is not for the purist as it still refers to sysaltfiles but it will work and also will reverse engineer the database owner for you, which could...
June 22, 2009 at 2:00 pm
then SQL is using about 6GB of memory (for buffer cache), the value in task manager is incorrect (due to AWE being used)
June 22, 2009 at 10:26 am
what does the perfmon counter show? I would trust that value
June 22, 2009 at 8:41 am
looks like you need to start off by querying the value of mirroring_role in table sys.database_mirroring and take it from there.
June 22, 2009 at 7:14 am
Theres one in the SQL 2000 BOL under dbcc showcontig
http://msdn.microsoft.com/en-us/library/ms175008.aspx
It could be amended slightly to do either indexdefrag or dbreindex
June 20, 2009 at 8:59 am
If this is code run only occasionally you could use openrowset method which is remote access without the need for a linked server.
You could use a table with server names...
June 19, 2009 at 5:16 pm
If you have SQL memory set to take 6.5GB on a 32bit system I presume you have AWE enabled? In which case task manger does not correctly show memory usage....
June 19, 2009 at 5:08 pm
tosscrosby (6/19/2009)
sarvesh singh (6/18/2009)
our teste serverI don't even want to know! 😉
we always have a failover pair for those type of servers. 😉
June 19, 2009 at 11:20 am
Viewing 15 posts - 3,541 through 3,555 (of 4,745 total)