Questions tagged [dbachecks]
dbachecks is a Windows PowerShell module created as a framework by and for SQL Server pros who need to validate their environments.
9
questions
1
vote
0
answers
79
views
dbatools, DbcCheck Does not use Saved credential
Last week I deployed dbccheck on the production environment. I found strange thing and have no idea what the problem is.
We have 40 db vm's which are not domain joined. Each of db vm's have same ...
- 11
0
votes
0
answers
120
views
query to know list of the queries executed by all users from the last one hour with Username , SQL query and its execution time
I would like to know the list of the queries executed by all users from the last one hour with Username , SQL query and its execution time details.
Please share the query to get those details in ...
- 131
-1
votes
1
answer
56
views
How to send dbachecks output to a file on disk?
How do you send the dbachecks output to a file on disk?
I tried the following but it resulted with the output on screen and a 0 kb file on disk.
Invoke-DbcCheck -Check Database -SqlInstance myserver -...
- 1,036
2
votes
1
answer
493
views
DBCC CHECKDB getting terminated abnormally
We have a SQL Server 2014 set up on Always on AG with one primary node and 2 secondary nodes.
On the primary node, DBCC CHECKDB for one of the databases is scheduled on SQL agent job. This job was ...
- 31
0
votes
3
answers
206
views
How to perform bulk delete and release free space?
Good Afternoon,
We have a database that wasn't been an archive anytime. The database has grown tremendously and we are running short of space. Hence there is a need to do a bulk delete and free space. ...
1
vote
0
answers
167
views
Unable to execute dbachecks command
i installed dbachecks module in a server. but when i am trying to execute get-dbccheck, it is throwing the below error
Populating RepositorySourceLocation property for module Pester.
VERBOSE: Loading ...
0
votes
1
answer
2k
views
Encrypt connection when using sqlcmd
Trying to connect database with an encrypted connection, tried below sql queries:
sqlcmd -N -E -S tcp:SQLSERVER,1234 -U username -P password -d Database -Q "INSERT INTO table1 VALUES(1,2,2)
ERROR:...
- 3
1
vote
1
answer
286
views
How to monitor Mongo databases and Cloud servers? [closed]
We have mongo databases installed in AWS and Azure based servers. We need to monitor the Mongo databases and Cloud servers on daily basis. Is there any way to healthcheck the databases and servers ?
...
- 11
1
vote
2
answers
289
views
dbatools, DbcCheck LastBackup
Last week I started testing dbccheck on my test system. I found one strange thing, and I have no idea what is the problem, last fullbackup is few hours old, but dbccheck print an error.
Following you ...
- 11