Viewing 15 posts - 1,051 through 1,065 (of 2,463 total)
GilaMonster (8/16/2011)
That 0 seconds, 0% often means the rollback is stuck waiting for something, maybe DTC, maybe a resource in the DB. Check for that.
How to approach here ?...
August 16, 2011 at 6:04 am
anthony.green (7/22/2011)
under registered servers --> database engine --> central management servers
add in your central server, then register any child servers under the central...
July 22, 2011 at 1:17 am
ALZDBA (7/21/2011)
- are your cpu-cores dedicated or do all instances compete for all cores ?
we dont have dedicated CPUs
ALZDBA (7/21/2011)
- what kind of io system / layout is in use...
July 21, 2011 at 3:27 am
Sorry i forgot to tell the memory distribution
instances :
1st : 2 gb
2nd : 2 gb ( mirrored from 1st)
3rd : 2 gb
4th : 2 gb...
July 21, 2011 at 2:16 am
no , before shutting down the sql server, check point will be raised that will flush dirty data and log pages from the buffer cache of the current database.So you...
July 13, 2011 at 6:12 am
have you tried xp_cmdshell command, is it working ?
July 13, 2011 at 6:07 am
gsuvarnarekha (7/4/2011)
Could any body tel me what are the steps to enable sql profiler and to check whether its enable or not.
i think this is knowledge gathering question if...
July 5, 2011 at 5:44 am
Are you using any job to refresh the snapshot ? if yes then you can the schedule
July 5, 2011 at 5:41 am
halifaxdal (7/5/2011)
I want to then remove the oldest version when making newer backup, so the bak is always 4 version size and always keeps a month history.
this statement is...
July 5, 2011 at 5:34 am
koustav_1982 (7/4/2011)
1.The index at the end , in the last few pages of a Dictionary serves as the nonclustered index.
Yes , its called biblography(indexing)
koustav_1982 (7/4/2011)
July 4, 2011 at 5:23 am
Syed Jahanzaib Bin hassan (6/30/2011)
Are you using Named Instance ?
Yes
Syed Jahanzaib Bin hassan (6/30/2011)
June 30, 2011 at 1:53 am
A lot of area ,which can be get affected like CPU, IO usage, Log size , there might be blocking.
my take would be to do the deletion in batches...
June 30, 2011 at 1:22 am
"\etworklocation\"
Check above location is accessible locally from where the backup has been taken ? OR is there any recent change in permissions?
June 28, 2011 at 4:35 am
Additionally, we can have a stored proc with parameters ( where clause conditions) and handle the other restriction like "no of rows need to be updated" or we can handle...
June 27, 2011 at 6:56 am
i ran the above query against all system db nit no luck
and
below is the figures of tempdb in (MB)
USED (%)26.90 (7.68 %)
FREE (%)323.55 (92.32...
June 22, 2011 at 6:56 am
Viewing 15 posts - 1,051 through 1,065 (of 2,463 total)