Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [query]

196 questions
0
votes
1 answer

How to record/log query execution stats for long running SQL Queries?

I work on a system that comprises of a SQL Server 2012 DB server that is queried frequently with complex queries. Sometimes these queries take more than 2 or 3 mins to return. How can I record or log the execution plans for these queries when they…
Bhaskar
  • 141
  • 1
  • 5
0
votes
0 answers

LDAP Query Of All Users In Various Groups In A Specific ActiveDirectory OU

I need to configure Atlassian Crowd to query all the users in my AD server that are in various groups in a top-level OU. The DN for the OU is "OU=Atlassian,DC=NNNN,DC=com". The various groups would be "CN=,OU=Atlassian,DC=NNNN,DC=com". There are…
alphadogg
  • 285
  • 4
  • 17
0
votes
1 answer

I am confused about the Authoritative DNS Server actual definition

I search for this a lot and the answer is the same everywhere: Authoritative servers give either the answer or "NO", the host does not exist. Non-Authoritative servers use either cache or a forwarder. please just answer these questions and i'm on…
Shnd
  • 275
  • 3
  • 11
0
votes
3 answers

ldap query with nested group

I try to build a ldap query to MS Active Directory. I found that there is a LDAP_MATCHING_RULE_IN_CHAIN type to do so. Which results in the follow…
Thomas
  • 177
  • 3
  • 13
0
votes
1 answer

Concurrent MySQL processes

I have a file, let's call it a.php, which executes a long cycle of iterations, each one of them makes some queries to the database. To complete the cycle, it takes quite some time (some hours). My problem is that, while a.php is being processed, if…
aur0n
  • 111
  • 1
0
votes
2 answers

bind cache not used?

i installed a classic bind9 dns server inside a local network, working as a forwarding dns server, there is my config file (i just added my ISP DNS servers as forwarders): options { directory "/var/cache/bind"; forwarders { 212.27.40.240; …
Matt
  • 1
0
votes
3 answers

Restore SQL Database From BAK File using a SQL Query

I have my database backing up to the hard disk in the format of BAK file. I am trying to restore that backup, but I unable to do so. Here is my query: ALTER DATABASE DBASE SET SINGLE_USER WITH ROLLBACK IMMEDIATE RESTORE DATABASE DBASE FROM DISK =…
nate
  • 417
  • 5
  • 8
  • 17
0
votes
1 answer

Diagnosing where all the queries are coming from

We have an issue where a site on a shared hosting account is going over the allowed query limit per user; that is set at 100k queries/hr. The site shouldn't be generating that amount of queries TBH and so we are trying to track down where they are…
Brett
  • 319
  • 1
  • 3
  • 12
0
votes
1 answer

Anyone knows what 173lo.com is - top entry on my BIND DNS server

Administer a DNS server running BIND DNS. We use dnstop to monitor queries. I have 173lo.com as top query with highest count and I'm wondering what the domain is, I can't find really useful information on the domain. Does anyone know about…
Ugorji Nnanna
  • 43
  • 1
  • 5
0
votes
1 answer

Powershell - query non-standard group members in an OU?

I am looking to create a script which will only show users in an OU who are members of "non-standard" groups. For example, all users in the "Accounting" OU will be members of at least one group with "Accounting" in its name. Example:…
user201727
  • 1
  • 1
0
votes
1 answer

Why does this RewriteRule in httpd not work?

I tried to set this RewriteCond in httpd 2.4.4: ... RewriteCond expr "%{QUERY_STRING} =~ /welcome/" RewriteRule ^(.*)$ %1\.html So, if I visit https://localhost/?welcome , for example, I should see the page https://localhost/welcome.html. Instead,…
sl34x
  • 23
  • 4
0
votes
1 answer

Centos Bind remote query issue

I have trouble with remote access to dns server Ip address of server is 199.175.53.128 I run this command from server host cloudauth.me. 199.175.53.128 this command returns Using domain server: Name: 199.175.53.128 Address:…
Taleh Ibrahimli
  • 123
  • 5
0
votes
2 answers

how to see queries to oracle database

the database in question is Oracle 10g Enterprise software the tools available are Toad, SQL Developer, and other built in oracle tools I have an application server within the network, alongside the database server within the network. I also have a…
CQM
  • 117
  • 8
0
votes
3 answers

Redirect MySQL queries to another server

In order to lower system usage I'm planning to use another server to store my databases. so how can I redirect MySQL queries to another server or make MySQL to store databases on another server?
Zim3r
  • 1,454
  • 5
  • 24
  • 45
0
votes
1 answer

How to speed up a MySQL Import

I posted a related question on askubuntu.com, but this may be a better place and way to ask it. I'm working on a way to speed up a db import. Currently the import is taking a week, give or take a few days, which is unacceptable, and I know it can…
jobu1324
  • 485
  • 4
  • 9
  • 17
1 2 3
…
13 14