Viewing 15 posts - 256 through 270 (of 469 total)
Its a bug with maintenance plans and jobs on SQL 2005 post SP2...I believe there is a hotfix for it...I went on to install build 4028 which is CTP for...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 8, 2009 at 11:40 am
Did you reboot the server after patching??
Thanks!!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 8, 2009 at 11:32 am
Depends on what type of RAID is the existing disk..and the performance would boost if it were to be moved to a disk with higher throughput..but first we need to...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 8, 2009 at 10:47 am
Do you have IIS installed? If so is it on the DB server or on a separate app server?
Thanks!!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 8, 2009 at 10:39 am
You just have 100MB of available memory...sounds like a bottleneck..but lets not stop there..what are the RAID configurations?
Is tempdb on a separate disk? What kind of activity goes on these...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 8, 2009 at 10:37 am
4 GB of RAM is a dead rubber...I wouldn't be scratching my head why the server is slow...just ADD RAM..
Did you even check how much the BUFFER CACHE HIT ratio...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 8, 2009 at 10:27 am
Check the SQL ErrorLogs and the Windows Event logs for any thing unwanted.
Thanks!!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 8, 2009 at 9:58 am
Last but not the least would be troubleshooting issues as and when they come..well to be a good DBA, investigate the problem before the users call you..hey somethings wrong with...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 5, 2009 at 7:41 am
Always have the backup handy..make sure there is no corruption of data...thanks!!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 5, 2009 at 7:39 am
Iqtedar: Does your developer need to do a point in time restore with his database..only in that case does he need to put the database in full recovery mode..which calls...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 3, 2009 at 7:18 pm
Paul..I hope you are having fun during your holidays...I would like your insights on this issue once you are here please..thanks!!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 3, 2009 at 7:15 pm
Well Barry..it seems you just learnt a new thing in this New Year....:P
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 2, 2009 at 1:21 pm
reddi..to create any object you would need to use the dbo ( database owner) role, but how do you intend to keep track of all the objects that this user...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 2, 2009 at 1:17 pm
Is this for a specific user account or for an app account??
If you don't want to give the syadmin role, then these are some of the options
CREATE DATABASE permission defaults...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 2, 2009 at 9:49 am
What kicks off the report generating process? Are they stored at the same location..please provide some more details like are you using report server to create this?
Thanks!!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 2, 2009 at 9:09 am
Viewing 15 posts - 256 through 270 (of 469 total)